Oracle Exam 1Z0-082 Topic 3 Question 9 Discussion

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

Question #: 9
Topic #: 3

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? (Choose two.)

AThe second ROLLBACK command does nothing

BThe second ROLLBACK command replays the delete

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

DThe second ROLLBACK command undoes the insert

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

Show Suggested Answer

Suggested Answer: C, D

by Corinne at May 03, 2022, 04:47 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!