Lab 4.2 Self-Review Questions

In order to test your progress, you should be able to answer the following questions.


User A can ROLLBACK User B's insert statement.

  1. _____ True

  2. _____ False


When a COMMIT has been issued, which of the following are true? (Choose all that apply.)

  1. _____ All memory holds on the data have been released.

  2. _____ All data inserts are available to other users.

  3. _____ You have to get married.

  4. _____ The transaction is not finished because SQL statements are still pending.


What defines a logical unit of work?

  1. _____ From one SAVEPOINT to the next .

  2. _____ From one ROLLBACK to the next.

  3. _____ From one COMMIT to the next.

  4. _____ All of the above.


Which of the following is an advantage of using SAVEPOINTS in a PL/SQL block?

  1. _____ It prevents inconsistent data.

  2. _____ It allows one to group code into manageable units.

  3. _____ It prevents one from duplicating a primary key.

  4. _____ It locks rows and prevents other users from updating the same row.

Answers appear in Appendix A, Section 4.2 .

Oracle PL[s]SQL by Example
Oracle PL[s]SQL by Example
ISBN: 3642256902
Year: 2003
Pages: 289 © 2008-2017.
If you may any questions please contact us: