Exam 1z0-071 topic 1 question 36 discussion

A. The second ROLLBACK command replays the delete. This is false. The second rollback undoes the INSERT operation but does not affect the DELETE. The first rollback already restored the rows deleted before the savepoint. B. The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row. This is false. The first rollback restores the deleted rows but does not commit the inserted row. The insert is still in an uncommitted state until the second rollback is issued. C. The first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed. This is true. The first rollback restores the deleted rows (100 rows), and the inserted row is still uncommitted, meaning it will be undone by the second rollback. D. The second ROLLBACK command undoes the insert. This is true. The second rollback undoes the insert, as it was the most recent uncommitted operation at the time. E. The second ROLLBACK command does nothing. This is false. The second rollback does undo the inserted row ('ADV112', 'Adventures of Tom Sawyer'), so it does something.

CD are correct

For me DE

Seems right!

Rollback without savepoint: - end of the transaction - delete savepoints - undoes all changes in the transactions