| 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. |
لطفا منتظر باشید ...
