Examine the description of the BOOKS table:The table has 100 rows.Examine this sequence of statements issued in a new se
Posted: Sun Jun 11, 2023 3:55 pm
Examine the description of the BOOKS table:The table has 100 rows.Examine this sequence of statements issued in a new session:INSERT INTO books VALUES ('ADV112', 'Adventures of Tom Sawyer', NULL, NULL);SAVEPOINT a;DELETE FROM books;ROLLBACK TO SAVEPOINT a;ROLLBACK;Which two statements are true? (Choose two.)
A. The second ROLLBACK command replays the delete.
B. The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row.
C. The first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed.
D. The second ROLLBACK command undoes the insert. E. The second ROLLBACK command does nothing.
- Examine The Des 1 (33.64 KiB) Viewed 276 times
B. The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row.
C. The first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed.
D. The second ROLLBACK command undoes the insert. E. The second ROLLBACK command does nothing.