Oracle Database Administration II — Question 135

Which three are true about the FLASHBACK DATABASE feature? (Choose three.)

Answer options

• A. FLASHBACK LOGS are archived after a log switch.
• B. A database can be flashed back using SQL*PLUS.
• C. Queries and DML have the same FLASHBACK LOG overhead when flashback is enabled for a database.
• D. FLASHBACK DATABASE only uses FLASHBACK LOGS to get the database to the desired flashback time.
• E. It always generates REDO and UNDO.
• F. It requires that the target database be in ARCHIVELOG mode.

Correct answer: B, D, F

Explanation

Option B is correct because SQL*PLUS can indeed be used to perform a flashback operation. Option D is also accurate as FLASHBACK DATABASE exclusively utilizes FLASHBACK LOGS for restoring the database to a specific point in time. Finally, option F is true since ARCHIVELOG mode is required for the FLASHBACK DATABASE feature to function. The other options are incorrect because they either misrepresent the behavior of FLASHBACK LOGS or the overhead associated with queries and DML.