Question 188:
Your database is running in NOARCHIVLOG 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?
Answer options:
A. It executes successfully and sets the Fast Recovery Area as the local archive destination. B. It executes successfully and issues a warning to set LOG_ARCHIVE_DEST while opening the database. C. It fails and returns an error about LOG_ARCHIVE_DEST not being set. D. It executes successfully and sets $ORACLE_HOME/dbs as the default archive destination.