nerdexam
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

1Z0-071 question #244 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)
  • A
    4% (1)
  • B
    4% (1)
  • C
    86% (24)
  • D
    7% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice