1Z0-083: Oracle Database Administration II

1Z0-083: Oracle Database Administration II practice questions, page 8 of 8, with answer review and explanations.

Question 36

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

  1. FLASHBACK QUERY can retrieve REDO records from ONLINE and ARCHIVED REDO LOG files.
  2. FLASHBACK VERSION QUERY can retrieve REDO records from ONLINE and ARCHIVED REDO LOG files.
  3. FLASHBACK TABLE can undrop a column.
  4. FLASHBACK DROP can undrop an index when undropping a table.
  5. After a database is restored from flashback logs using the FLASHBACK DATABASE command, it is sometimes rolled forward using redo logs.