Q36
Which two are true about Oracle Flashback features? (Choose two.)
- 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.
DE
A, B are Wrong. Flashback Query & Version Query need Undo not Redo C is Wrong. D is Correct. Assuming that an index is not dropped before dropping a table. E is Correct