Archiving Redo log   «Prev  Next»
 

Redolog Files - Quiz

Each question is worth one point. Select the best answer or answers for each question.

1. Which of the following actions will place a database into archivelog mode?
Please select the best answer.
  A. Mount the database and then issue the ALTER SYSTEM ARCHIVE LOG START command.
  B. Open the database and then issue the ALTER DATABASE ARCHIVE LOG command.
  C. Open the database and then issue the ALTER SYSTEM ARCHIVE LOG START command.
  D. Mount the database and then issue the ALTER DATABASE ARCHIVE LOG command.

2. Which of the following parameter settings enables automatic archiving?
Please select the best answer.
  A. archive_log_start = true
  B. log_archive_start = true
  C. archive_log_auto = true
  D. log_archive_auto = true

3. Why might you choose to run a database in archivelog mode, but without enabling automatic archiving?
Please select the best answer.
  A. You are archiving to tape and you can't leave the tape mounted continuously.
  B. You have two archive log destinations and want log files copied to both.
  C. You are archiving to disk and aren't sure that you have enough room for the log files.
  D. You want the benefits of archivelog mode without dedicating space for archived log files.