Oracle
1Z0-082 · Question #30
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…
The correct answer is D. The second ROLLBACK command undoes the insert E. The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted. You've hit your weekly limit · resets 5am (America/New_York)
SQL and PL/SQL
Question
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.)
Options
- AThe second ROLLBACK command does nothing
- BThe second ROLLBACK command replays the delete
- CThe first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row
- DThe second ROLLBACK command undoes the insert
- EThe first ROLLBACK command restores the 101 rows that were deleted and commits the inserted
How the community answered
(47 responses)- A6% (3)
- B11% (5)
- C4% (2)
- D79% (37)
Explanation
You've hit your weekly limit · resets 5am (America/New_York)
Topics
#savepoints#ROLLBACK#transaction control#DML
Community Discussion
No community discussion yet for this question.