SQL Pivot Quiz Questions and Answers PDF Download - 417

A pivot clause allows creation of

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

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;

Triggers can be disabled by using the command

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

The research on parallel and distributed databases started over the period

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

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