Q119. 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 LOGfiles.
- 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 issometimes rolled forward using redo logs.
Answer: D,E