Oracle
1Z0-071 · Question #244
View the Exhibit and examine the structure of the BOOKS table. The BOOKS table contains details of 100 books. Examine the commands executed and their outcome: Which statement is true?
The correct answer is C. The first rollback restores the 101 rows that were deleted and the second rollback causes the row. See the full explanation below for the reasoning.
Question
View the Exhibit and examine the structure of the BOOKS table. The BOOKS table contains details of 100 books. Examine the commands executed and their outcome:
Which statement is true?
Exhibit
Options
- ABoth ROLLBACK commands restore the 101 rows that were deleted.
- BBoth ROLLBACK commands restore the 100 rows that were deleted.
- CThe first rollback restores the 101 rows that were deleted and the second rollback causes the row
- DThe first rollback restores the 100 rows that were deleted and the second rollback commits only
How the community answered
(28 responses)- A4% (1)
- B4% (1)
- C86% (24)
- D7% (2)
Community Discussion
No community discussion yet for this question.
