Which statement describes the consequences?
A. No SQL statement would be rolled back.
B. Both the DELETE statements would be rolled back.
C. Only the second DELETE statement would be rolled back.
D. Both the DELETE statements and the UPDATE statement would be rolled back.
Answer:A
Which statement describes the consequences?
A. No SQL statement would be rolled back. B. Both the DELETE statements would be rolled back. C. Only the second DELETE statement would be rolled back. D. Both the DELETE statements and the UPDATE statement would be rolled back.
Explanation:The SAVEPOINT statement names and marks the current point in the processing of a transaction. With the ROLLBACK TO statement, savepoints undo parts of a transaction instead of the whole transaction.