Oracle Database Administration II — Question 3

Which two are true about Oracle Flashback features? (Choose two.)

Answer options

• A. FLASHBACK QUERY can retrieve REDO records from ONLINE and ARCHIVED REDO LOG files.
• B. FLASHBACK VERSION QUERY can retrieve REDO records from ONLINE and ARCHIVED REDO LOG files.
• C. FLASHBACK TABLE can undrop a column.
• D. FLASHBACK DROP can undrop an index when undropping a table.
• E. After a database is restored from flashback logs using the FLASHBACK DATABASE command, it is sometimes rolled forward using redo logs.

Correct answer: D, E

Explanation

Option D is correct because FLASHBACK DROP allows for the recovery of an index associated with an undropped table. Option E is also correct as it describes the process of rolling forward a database after a FLASHBACK DATABASE operation using redo logs. The other options are incorrect as they either misrepresent the capabilities of the FLASHBACK features or describe actions that cannot be performed.