O'Reilly logo

OCA: Oracle 10g™ Administration I: Study Guide by Matthew Weishan, Joseph C. Johnson, Bob Bryla, Chip Dawes

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required