Oracle
1Z0-062 · Question #217
Your database is running in NOARCHIVING mode. Examine the following parameters: You execute the following command after performing a STARTUP MOUNT: SQL> ALTER DATABASE ARCHIVELOG; Which statement is t
Sign in or unlock 1Z0-062 to reveal the answer and full explanation for question #217. The question stem and answer options stay visible for context.
Performing Backup and Recovery
Question
Your database is running in NOARCHIVING mode. Examine the following parameters:
You execute the following command after performing a STARTUP MOUNT:
SQL> ALTER DATABASE ARCHIVELOG; Which statement is true about the execution of the command?
Options
- AIt executes successfully and sets the Fast Recovery Area as the local archive destination.
- BIt executes successfully and issues a warning to set LOG_ARCHIVE_DEST while opening the
- CIt fails and returns an error about LOG_ARCHIVE_DEST not being set.
- DIt executes successfully and sets $ORACLE_HOME/dbs as the default archive destination.
Unlock 1Z0-062 to see the answer
You've previewed enough free 1Z0-062 questions. Unlock 1Z0-062 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#ARCHIVELOG mode#NOARCHIVELOG mode#LOG_ARCHIVE_DEST#database startup