Oracle Database 12c: Installation and Administration — Question 41

Which two are prerequisites for performing a flashback transaction? (Choose two.)

Answer options

• A. Flashback Database must be enabled.
• B. Undo retention guarantee for the database must be configured.
• C. EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.
• D. Supplemental logging must be enabled.
• E. Recycle bin must be enabled for the database.
• F. Block change tracking must be enabled tor the database.

Correct answer: B, D

Explanation

The correct answers are B and D because both the undo retention guarantee and supplemental logging are essential for successfully performing a flashback transaction. While enabling Flashback Database (A) and configuring EXECUTE privileges (C) are important for other flashback operations, they are not specifically required for the transaction flashback itself. Options E and F are also not prerequisites for performing a flashback transaction.