Oracle Exam 1Z0-082 Topic 3 Question 88 Discussion

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

Question #: 88
Topic #: 3

[All 1Z0-082 Questions]

Which two statements are true regarding a SAVEPOINT? (Choose two.)

ARolling back to a SAVEPOINT can undo a CREATE INDEX statement

BRolling back to a SAVEPOINT can undo a TRUNCATE statement

COnly one SAVEPOINT may be issued in a transaction

DA SAVEPOINT does not issue a COMMIT

ERolling back to a SAVEPOINT can undo a DELETE statement

Show Suggested Answer

Suggested Answer: A, C

by Alaine at Mar 15, 2024, 10:53 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Tomoko

5 days ago

Haha, I bet the exam writer is trying to trick us with that CREATE INDEX statement. Everyone knows SAVEPOINT can't undo DDL operations. I'm going with C and D.

upvoted 0 times

...

Delila

7 days ago

I think B and D are the correct answers. SAVEPOINT doesn't commit the transaction, and it can undo a TRUNCATE statement, but not a CREATE INDEX.

upvoted 0 times

...

Arlette

10 days ago

A and E are the correct statements. I'm pretty sure SAVEPOINT can undo DML statements like DELETE and UPDATE, but not DDL statements like CREATE INDEX.

upvoted 0 times

...