RelationalDBDesign RelationalDBDesign

Recovery File Structures   «Prev  Next»

Archive log file - Quiz

1. Which of the following statements is true about archive log files? Please select all the correct answers.
  A. LGWR is used to write archive log information.
  B. LOG_ARCHIVE_DUPLEX_DEST is set in the init.ora file and indicates the secondary archive log location.
  C. Archive log files are copies of information from the redo log buffer.
  D. Archiving of redo log information can occur manually or automatically.

2. CKPT coordinates the flushing of memory buffers to disk by which of the following processes? Please select the best answer.
  A. DBWR and ARCH
  B. DBWR and LGWR
  D. LGWR and ARCH

3. SCN is used during a checkpoint to synchronize which of the following data file(s)? Please select the best answer.
  A. Redo log files, control files, data files, archive log files
  B. Redo log files, control files, data files
  C. Redo log files, control files
  D. Redo log files

4. The parameter LOG_CHECKPOINT_TO_ALERT can be used for which purpose? Please select the best answer.
  A. Indicate that there is a corrupt log file during checkpoint processing
  B. Identify which log file is currently being written to
  C. Determine if checkpoints are occurring often enough
  D. Updates the control file with the last checkpoint SCN