OCP: Oracle 10g Administration II Study Guide: Exam 1Z0-043

5.7. Review Questions

1. What type of recovery is the Flashback Database best suited for? (Choose all that apply.)

   1. User error

   2. Physical corruption

   3. Logical corruption

   4. Media failure

2. Flashback Database recovery can recover from which of the following failure scenarios?

   1. Loss of control file

   2. Dropping a tablespace through RESETLOGS

   3. A user error that resized datafiles to a smaller size

   4. A large truncated table or group of tables

3. What new background process is responsible for writing before block images and recovering from the Flashback Database log?

   1. RWVR

   2. RVWR

   3. RWRV

   4. RVRW

4. What are the benefits of the flash recovery area in the recovery and backup process?

   1. Recovery efficiency is improved because all files are stored on tape media for fast access.

   2. Recovery efficiency is improved ...