Exam 1z0-082 All Questions

View all questions & answers for the 1z0-082 exam

Exam 1z0-082 topic 1 question 82 discussion

Actual exam question from Oracle's 1z0-082

Question #: 82
Topic #: 1

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.)

A. The second ROLLBACK command does nothing
B. The second ROLLBACK command replays the delete
C. The first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed
D. The second ROLLBACK command undoes the insert
E. The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row

Show Suggested Answer

Suggested Answer: CD 🗳️

by you1234 at June 25, 2020, 5:50 p.m.

Comments

Submit Cancel

you1234

Highly Voted 4 years, 6 months ago

C & D is correct one

upvoted 25 times

Ekos

4 years ago

i agree

upvoted 4 times

...

Guhborges

3 years, 1 month ago

I agree, C & D

upvoted 2 times

...

yukclam9

Highly Voted 3 years, 8 months ago

to me the insert does not make sense. why we are inserting characters to a date column?

upvoted 7 times

Reiwardy

2 years, 1 month ago

That’s why they are trying to rollback the stuff.

upvoted 2 times

...

LrnsTgh

3 years, 4 months ago

😂 LOL. very good eyes

upvoted 3 times

...

Oracle2020

Most Recent 8 months, 3 weeks ago

I agree C, D is correct

upvoted 3 times

...

ErickZc

10 months ago

Selected Answer: CD

The correct answer is C,D I Tested it in my local database 19.11.0.0.0 COUNT(*) ---------- 10 1 row selected. 1 row created. Savepoint created. 11 rows deleted. Rollback complete. COUNT(*) ---------- 11 1 row selected. Rollback complete. COUNT(*) ---------- 10 1 row selected.

upvoted 2 times

...

feixiang

1 year, 4 months ago

the SQL INSERT is wrong

upvoted 2 times

...

musafir

1 year, 4 months ago

Selected Answer: CD

C D is correct

upvoted 2 times

...

mamadu

1 year, 5 months ago

Selected Answer: A

There is only one correct answer here A.

upvoted 2 times

mamadu

1 year, 5 months ago

the first rollback finishes the DELETE transaction, so no transaction open for second rollback.

upvoted 1 times

...

LeandroHPN

2 years, 5 months ago

Selected Answer: CD

C , D is correct.

upvoted 2 times

...

algerianphoenix

2 years, 7 months ago

Even though it is asked for "two" correct answers, I only found D as correct, the others make no sense to me, especially the SQL INSERT itself is wrong.

upvoted 1 times

...