SQL Pivot Practice Test PDF Download eBook p. 417

MCQ: A pivot clause allows creation of

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

MCQ: 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: Triggers can be disabled by using the command

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

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

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

MCQ: 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