Q138 Examine the description of the BOOKS table

Q138 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 does nothing
• (B). The second ROLLBACK command replays the delete
• (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 first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row