OCA: Oracle 10g™ Administration I: Study Guide

8.5. Review Questions

1. What will be the salary of employee number 189 at the completion of the following SQL statements?

   update emp set salary = 1000 where employee_num = 189;
   savepoint save_1;
   update emp set salary = salary * 1.1 where employee_num = 189;
   savepoint save_2;
   update emp set salary = salary * 1.1 where employee_num = 189;
   savepoint save_3;
   rollback to savepoint save_2;
   commit;
   update emp set salary = 1500 where employee_num = 189;
   savepoint save_4;
   rollback to save_4;
   commit;

   1. 1000

   2. 1100

   3. 1111

   4. 1500

2. Which of the following commands returns an error if the transaction starts with SET TRANSACTION READ ONLY?

   1. ALTER SYSTEM

   2. SELECT

   3. ALTER USER

   4. SET ROLE

3. Which of the following commands is most likely to generate an error message? (Choose two.)

   1. ALTER SYSTEM ...