Multiple choice technology databases

You have performed the first step in placing your database into ARCHIVELOG mode. The second step is deciding whether the online redo log files are to be archived automatically or manually. which action should you take to enable archiving an instance startup?

  1. Set the LOG_ARCHIVE_START parameter to TRUE in the initialization parameter file.

  2. Automatic archive is the default when ARCHIVELOG mode is set. No further actions are required.

  3. Set the LOG_ARCHIVE_MAX_PROCESSES parameter to n (where n is the number of Archiver process) in the initialization parameter file.

  4. Immediately after setting the database in ARCHIVELOG mode, in SQL*Plus select automatic archiving using the syntax : ALTER DATABASE SET LOG_ARCHIVE_START=TRUE
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The LOG_ARCHIVE_START initialization parameter controls automatic archiving of redo log files. Setting it to TRUE in the parameter file enables automatic archiving when the instance starts. Automatic archiving is not the default (option B). LOG_ARCHIVE_MAX_PROCESSES (option C) controls the number of archiver processes, not whether archiving is enabled. Option D incorrectly tries to set LOG_ARCHIVE_START with ALTER DATABASE.

Keep practicing — related questions