1z0-083 Practice Test

1z0-083 Practice Test 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.