Oracle Database 12c: Advanced Administration — Question 117

You want to create a guaranteed restore point for your database by executing the command:
SQL> CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE;
Identify two prerequisites for the successful execution of this command.

Answer options

• A. The database must be running in archivelog mode.
• B. Flashback Database must be enabled.
• C. Fast Recovery Area must be enabled.
• D. The recyclebin must be enabled for the database.
• E. Undo retention guarantee must be enabled.
• F. A database backup must be taken.

Correct answer: A, C

Explanation

For the command to successfully create a guaranteed restore point, the database needs to be in archivelog mode to ensure that all transactions are logged. Additionally, the Fast Recovery Area must be enabled to store the necessary files for recovery. The other options are not prerequisites for this specific command.