In order to test your progress, you should be able to answer the following questions.
User A can ROLLBACK User B's insert statement.
When a COMMIT has been issued, which of the following are true? (Choose all that apply.)
_____ All memory holds on the data have been released.
_____ All data inserts are available to other users.
_____ You have to get married.
_____ The transaction is not finished because SQL statements are still pending.
What defines a logical unit of work?
_____ From one SAVEPOINT to the next .
_____ From one ROLLBACK to the next.
_____ From one COMMIT to the next.
_____ All of the above.
Which of the following is an advantage of using SAVEPOINTS in a PL/SQL block?
_____ It prevents inconsistent data.
_____ It allows one to group code into manageable units.
_____ It prevents one from duplicating a primary key.
_____ It locks rows and prevents other users from updating the same row.
Answers appear in Appendix A, Section 4.2 .