Oracle
1Z0-063 · Question #158
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…
The correct answer is A. The database must be running in archivelog mode. C. Fast Recovery Area must be enabled. See the full explanation below for the reasoning.
Question
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.
Options
- AThe database must be running in archivelog mode.
- BFlashback Database must be enabled.
- CFast Recovery Area must be enabled.
- DThe recycle bin must be enabled for the database.
- EUndo retention guarantee must be enabled.
- FA database backup must be taken.
How the community answered
(27 responses)- A74% (20)
- B4% (1)
- D4% (1)
- E4% (1)
- F15% (4)
Community Discussion
No community discussion yet for this question.