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

Paulene

1 months ago

Wow, this is a tricky one. I'm going to go with A and E, but I'm not 100% sure. Do SAVEPOINTS really work with TRUNCATE? That seems a bit odd to me.

upvoted 0 times

Merilyn

8 days ago

TRUNCATE is not affected by SAVEPOINTS, so B is not correct.

upvoted 0 times

...

Yan

9 days ago

I agree, rolling back to a SAVEPOINT can undo those statements.

upvoted 0 times

...

Quentin

15 days ago

I think A and E are correct. SAVEPOINTS can undo a CREATE INDEX and DELETE statement.

upvoted 0 times

...

Tomoko

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

Fernanda

2 months ago

Yeah, I agree. C and D are the correct statements regarding a SAVEPOINT.

upvoted 0 times

...

Zachary

2 months ago

I think you're right, SAVEPOINT can't undo DDL operations. I'll go with C and D as well.

upvoted 0 times

...

Delila

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

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

...