Oracle Database Administration II — Question 35

Which three are true about Database Point-in-Time Recovery? (Choose three.)

Answer options

• A. The database must have FLASHBACK DATABASE ON to perform Database Point-in-Time Recovery.
• B. The database must be in MOUNT state when performing Database Point-in-Time Recovery.
• C. Database Point-in-Time Recovery is performed by the Managed Recovery Process (MRP)
• D. The Database must be in ARCHIVELOG mode.
• E. The target point for the recovery must be specified as a stime or System Change Number (SCN).
• F. The database must be open RESETLOGS after Database Point-in-Time Recovery.

Correct answer: B, D, F

Explanation

The correct answers are B, D, and F because Database Point-in-Time Recovery requires the database to be in MOUNT state (B), must be in ARCHIVELOG mode (D), and needs to be opened with RESETLOGS after recovery (F). Options A, C, and E are incorrect as FLASHBACK DATABASE is not necessary for this recovery method, it is not performed by MRP, and the target point does not strictly have to be defined as a stime or SCN.