Lab 4.2 Self-Review Questions

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

1)	User A can ROLLBACK User B's insert statement. _____ True _____ False
2)	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.
3)	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.
4)	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 .