Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25

- Free Preparation Discussions

Oracle 1Z0-083 Exam - Topic 2 Question 128 Discussion

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

Question #: 128
Topic #: 2

[All 1Z0-083 Questions]

Which two are prerequisites for performing Flashback Transaction?

AFast Recovery Area must be enabled for the database

BThe EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK package.

CUndo retention guarantee must be configured for the database.

DA supplemental log must be enabled for the primary key.

EA supplemental log must be enabled for the primary key.

Show Suggested Answer

Suggested Answer: B, D

by Rochell at Apr 04, 2026, 03:29 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Alpha

1 month ago

I thought C was also needed?

upvoted 0 times

...

Jacquelyne

1 month ago

A and B are definitely the right ones!

upvoted 0 times

...

Penney

2 months ago

I thought supplemental logging was necessary, but I can't remember if it applies to both primary keys or just one of them.

upvoted 0 times

...

Buffy

2 months ago

I feel like the undo retention guarantee is also a prerequisite, but I can't recall if it's mandatory or just recommended.

upvoted 0 times

...

Francis

2 months ago

I remember something about needing the EXECUTE privilege on the DBMS_FLASHBACK package. That seems important for this feature.

upvoted 0 times

...

Hoa

3 months ago

I think the Fast Recovery Area needs to be enabled, but I'm not entirely sure if that's a requirement for Flashback Transactions.

upvoted 0 times

...