SQL Pivot Quiz with Answers PDF Download – Test 417

MCQ 2081: A pivot clause allows creation of:

1. Structured tabs
2. Cross-tabs
3. Nonstructural tabs
4. Dimensional tabs

MCQ 2082: The command for increase in annual salary are being made, and salaries of all instructors are to be increased by 5 percent, would be:

1. update instructor
   set salary=salary * 1.05;
2. update instructor
   set salary=salary * .05;
3. update into instructor
   set salary=salary * .05;
4. update to instructor
   set salary=salary * 1.05;

MCQ 2083: Triggers can be disabled by using the command:

1. Define trigger
2. Modify trigger
3. Alter trigger
4. Declare trigger

MCQ 2084: The research on parallel and distributed databases started over the period:

1. 1950s
2. 1960s
3. 1970s
4. 1980s

MCQ 2085: The method getColumns takes four arguments i.e. a catalog name, a scheme name, a table name and:

1. Column name
2. Column name pattern
3. Row name
4. Row name pattern