Archivelog | Noarchivelog   «Prev 

Database Archiving Mode - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. You have just performed a default database installation. To use noarchivelog mode, which initialization parameter(s) would you set?
Please select the best answer.
  A. LOG_ARCHIVE_DEST_n
  B. LOG_ARCHIVE_FORMAT
  C. LOG_ARCHIVE_DUPLEX_DEST
  D. You would not set any parameters

2. Which of the following is a true statement when you enable archivelog mode?
Please select the best answer.
  A. The backup taken just prior to the 'alter database archivelog' command will be your current backup.
  B. Entering the 'alter database archivelog' command will modify data in the control files and the redo log files.
  C. You will be able to perform online backups.
  D. The archive log files will use only the space allocated to the redo log files.

3. To configure archivelog mode, which parameter(s) should be set?
Please select all the correct answers.
  A. LOG_ARCHIVE_DEST_n
  B. LOG_ARCHIVE_DUPLEX_DEST
  C. LOG_ARCHIVE_FORMAT
  D. LOG_ARCHIVE_MODE

4. Which processes are actually involved in archiving redo log files?
Please select all the correct answers.
  A. LGWR
  B. ARCn
  C. DBW
  D. PMON

5. Configuring the database in archivelog mode allows you to perform which of the following recovery options?
Please select all the correct answers.
  A. Complete database recovery
  B. Point-in-time recovery
  C. Recovery to a specific system change number
  D. Recovery to a specific log file

6. You enable ARCHIVELOG mode on a database that already has several tables loaded with NOLOGGING bulk operations. Which statement is true?
Please select the best answer.
  A. The archived redo stream now fully protects those tables, since ARCHIVELOG mode is active.
  B. Those tables remain unrecoverable through media recovery unless FORCE LOGGING is also enabled.
  C. Oracle automatically converts NOLOGGING objects to LOGGING once ARCHIVELOG mode is enabled.
  D. NOLOGGING only affects performance, not recoverability.