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

Iola

1 months ago

Ugh, SQL questions are the worst. I'm just going to close my eyes and pick an answer at random. Maybe I'll get lucky and it'll be right!

upvoted 0 times

...

This is a tough one. I'm leaning towards D) because the second ROLLBACK command sounds like it would replay the delete. But then again, maybe the first ROLLBACK already took care of that. I'm just going to guess and hope for the best!

upvoted 0 times

Thaddeus

17 days ago

I think D) is the correct answer. The second ROLLBACK command replays the delete.

upvoted 0 times

...

Alonzo

1 months ago

Ha! This question is a real brain-teaser. I can't decide between A) and E). I guess I'll go with A) since it seems more logical, but who knows? Maybe the second ROLLBACK command does undo the insert. What a tricky SQL problem!

upvoted 0 times

...

Mila

2 months 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

Shonda

28 days ago

Let's wait for more opinions before deciding.

upvoted 0 times

...

Cristina

1 months ago

I believe B) is the correct option.

upvoted 0 times

...

Wenona

1 months ago

I'm not sure, but I think A) might be the answer.

upvoted 0 times

...

Margery

2 months ago

I think C) is correct too.

upvoted 0 times

...

Maile

2 months 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

Arlen

1 months ago

User 2

upvoted 0 times

...

Eliz

2 months ago

User 1

upvoted 0 times

...

Precious

3 months ago

But if the first ROLLBACK command restores the deleted rows, then the second one must undo the insert, right?

upvoted 0 times

...

Lanie

3 months ago

I disagree, I believe it's B and D.

upvoted 0 times

...

Precious

3 months ago

I think the correct answers are A and E.

upvoted 0 times

...

Oracle Exam 1Z0-071 Topic 5 Question 90 Discussion

Contribute your Thoughts:

Iola

Xenia

Thaddeus

Alonzo

Mila

Shonda

Cristina

Wenona

Margery

Maile

Arlen

Eliz

Precious

Lanie

Precious