When is it appropriate to use a sequence?

A. When you want to control the order in which triggers are fired.

B. When you want to control the order in which stored procedures can be invoked.

C. When you want to automatically generate a numeric value that is not tied to any specific column or table.

D. When you want to automatically generate a numeric value for each row that is added to a specific table.

Which statement will prevent concurrent application processes from performing anything other than read- only operations against a table named TAB1?

A. LOCK TABLE tab1 IN READ MODE

B. LOCK TABLE tab1 IN SHARE MODE

C. LOCK TABLE tab1 IN EXCLUSIVE MODE

D. LOCK TABLE tab1 IN READ-ONLY MODE

Which SQL statement should be used to select the minimum and maximum salaries (SALARY), by job code (JOB), from a table EMPLOYEE?

A. SELECT job, MIN(salary), MAX(salary) FROM employee GROUP BY job;

B. SELECT job, MIN(salary), MAX(salary) FROM employee ORDER BY job;

C. SELECT job, MIN(salary), MAX(salary) FROM employee GROUP BY job, MIN(salary), MAX(salary);

D. SELECT JOB, MIN(salary), MAX(salary) FROM employee ORDER BY job, MIN(salary), MAX(salary);

Which statement about BEFORE triggers is FALSE?

A. A BEFORE trigger can be used to perform validation of input data.

B. A BEFORE trigger can be used to automatically generate values for newly inserted rows.

C. A BEFORE trigger is fired for each row in the set of affected rows before the trigger event executes.

D. A BEFORE trigger is fired for each row in the set of affected rows instead of executing the trigger event.

Which statement about roll back operations is correct?

A. When a ROLLBACK statement is executed, all locks held by the terminating transaction are released.

B. When a ROLLBACK TO SAVEPOINT statement is executed, all locks acquired up to the savepoint are released.

C. When a ROLLBACK TO SAVEPOINT statement is executed, all locks acquired after the savepoint are released.

D. When a ROLLBACK statement is executed, all locks acquired for open cursors that were declared WITH HOLD, are held.