1Z0-067 · Question #5
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. SQL> select flashback_on from v$database; SQL> CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE; Restore point created. SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log…
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 recyclebin must be enabled for the database.
- EUndo retention guarantee must be enabled.
- FA database backup must be taken.
How the community answered
(20 responses)- A85% (17)
- B10% (2)
- F5% (1)
Explanation
SQL> select flashback_on from v$database; SQL> CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE; Restore point created. SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 113 Next log sequence to archive 115 Current log sequence 115
Topics
Community Discussion
No community discussion yet for this question.