Oracle Database 12c: Advanced Administration — Question 52

Your database is running in archivelog mode and Automatic Undo Management is enabled.
Which two tasks should you perform before enabling Flashback Database?

Answer options

• A. Enable minimal supplemental logging.
• B. Ensure that the db_flashback_retention_target parameter is set to a point in time (in minutes) to which the database can be flashed back.
• C. Enable the recyclebin.
• D. Enable undo retention guarantee.
• E. Enable Fast Recovery Area.

Correct answer: A, C

Explanation

Enabling minimal supplemental logging (Option A) is necessary to ensure that enough information is captured for consistent flashback operations. Option C, enabling the recyclebin, allows for easier recovery of dropped objects, which is beneficial when using Flashback Database. The other options are not required for enabling Flashback Database specifically.