Archivelog | Noarchivelog   «Prev 
 

Database Archiving Mode - Quiz

1. You have just performed a default database installation. To use noarchivelog mode, which init.ora parameter(s) would you set?
Please select the best answer.
  A. LOG_ARCHIVE_DEST
  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 archive’ command will be your current backup.
  B. Entering the ‘alter database archive’ 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
  B. LOG_ARCHIVE_DUPLEX_DEST
  C. LOG_ARCHIVE_FORMAT
  D. LOG_ARCHIVE_MODE
  E. The correct answers are A and C. A is correct because this init.ora parameter will indicate the location of your archive log files. C is correct because this will indicate the naming convention of your archive log files. B is incorrect because LOG_ARCHIVE_DUPLEX_DEST should be set if you want to duplex your archive log files. D is incorrect because LOG_ARCHIVE_MODE isn't a valid archivelog parameter.
  F. LGWR
  G. ARCH
  H. DBWR
  I. PMON

4. 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