Oracle
1Z0-071 · Question #316
Examine the description of the BOOKS table: The table has 100 rows. Examine this sequence of statements issued in a new session: Which two statements are true? (Choose two.)
The correct answer is C. The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted D. The second ROLLBACK command undoes the insert. See the full explanation below for the reasoning.
Question
Examine the description of the BOOKS table:
The table has 100 rows. Examine this sequence of statements issued in a new session:
Which two statements are true? (Choose two.)
Exhibits
Options
- AThe first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row
- BThe second ROLLBACK command replays the delete.
- CThe first ROLLBACK command restores the 101 rows that were deleted and commits the inserted
- DThe second ROLLBACK command undoes the insert.
- EThe second ROLLBACK command does nothing.
How the community answered
(45 responses)- A7% (3)
- B18% (8)
- C71% (32)
- E4% (2)
Community Discussion
No community discussion yet for this question.