Oracle Exam 1Z0-071 Topic 5 Question 90 Discussion

Actual exam question for Oracle's 1Z0-071 exam

Question #: 90
Topic #: 5

[All 1Z0-071 Questions]

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?

AThe first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed.

BThe second ROLLBACK command does nothing.

CThe first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row.

DThe second ROLLBACK command replays the delete.

EThe second ROLLBACK command undoes the insert.

Show Suggested Answer

Suggested Answer: C, D

by Gerry at Apr 21, 2024, 10:18 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-071 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Mila

6 days ago

I'm not sure about this one. The SAVEPOINT and ROLLBACK commands are confusing me. I'm going to go with C) because it seems like the most straightforward explanation, even though it might not be right.

upvoted 0 times

...

Maile

15 days ago

Wow, this question is tricky! I think the correct answer is A) and B). The first ROLLBACK command should restore the 101 rows that were deleted, but the inserted row would still need to be committed. And the second ROLLBACK command would do nothing since the first one already undid the delete.

upvoted 0 times

...