Oracle Database 12c: Installation and Administration — Question 128

Which three statements are true about Flashback Database? (Choose three.)

Answer options

• A. Flashback logs are written sequentially, and are archived.
• B. Flashback Database uses a restored control file to recover a database.
• C. The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area.
• D. Flashback Database can recover a database to the state that it was in before a reset logs operation.
• E. Flashback Database can recover a data file that was dropped during the span of time of the flashback.
• F. Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.

Correct answer: C, D, F

Explanation

The correct answers are C, D, and F because C accurately describes the automatic management of flashback logs in the Fast Recovery Area, D explains the capability to recover from a reset logs operation, and F details the process of using flashback logs and redo data. Options A and B are incorrect as they misrepresent how flashback logs are managed and the role of the control file in recovery.