|
Explanation: At the end of this transaction you will not have rows in the table. Incorrect Answers: 2: All transactions will be roll backed, so it will be no rows in the table. 3: It is possible to roll back to the same savepoint more than once. 4: Your last update will not fail because there is employee with ID 180 in the table and transactions have been rolled back only to the savepoint s2 before issue this update. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 279-285 Chapter 6: Manipulating Oracle Data
|