Oracle Database 12c: Advanced Administration — Question 113

Which two are prerequisites for performing Flashback Transaction?

Answer options

• A. A supplemental log must be enabled for the primary key.
• B. Undo retention guarantee must be configured for the database.
• C. Fast Recovery Area must be enabled for the database.
• D. The EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK package.
• E. Row movement must be enabled.

Correct answer: A, D

Explanation

The correct answers are A and D because a supplemental log for the primary key is essential to capture changes necessary for Flashback Transaction, and the EXECUTE privilege on the DBMS_FLASHBACK package is required for a user to perform the operation. The other options, while related to database configuration, are not directly prerequisites for executing Flashback Transaction.