Recovery File Structures   «Prev  Next»

Archive log file - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. Which statements correctly describe local archived redo logs in an ARCHIVELOG database?
Please select all the correct answers.
  A. LGWR normally creates local archived redo files directly from the redo log buffer.
  B. An archived redo log preserves redo from a completed online redo log sequence.
  C. Each member of a multiplexed group contains different redo, so all members must be combined to create an archive.
  D. Archiving can be automatic or manually requested.

2. During checkpoint processing, which process writes the required dirty database buffers to datafiles?
Please select the best answer.
  A. ARCn
  B. LGWR
  C. DBWn
  D. CKPT

3. What is the main recovery purpose of recording checkpoint progress?
Please select the best answer.
  A. Rewrite every archived redo file with the same current SCN.
  B. Record progress in datafile writes so instance recovery can identify where redo application must begin.
  C. Commit every transaction whose changed blocks have reached disk.
  D. Guarantee that all file headers always contain identical SCNs while the database is open.

4. What does enabling LOG_CHECKPOINTS_TO_ALERT do?
Please select the best answer.
  A. Automatically repairs redo corruption discovered during a checkpoint.
  B. Sets a fixed interval between successive checkpoints.
  C. Records checkpoint information in the alert log for review.
  D. Replaces CKPT by writing checkpoint metadata directly to control files.

5. A suitable datafile backup is available, but an archived redo sequence required to reach the chosen recovery target is missing. No alternate copy or other recovery path supplies the missing changes. What is the consequence?
Please select the best answer.
  A. Later archived logs automatically fill the gap.
  B. Checkpoint information reconstructs the missing redo.
  C. ARCHIVELOG mode guarantees that the target remains reachable.
  D. That restore-and-recover path cannot reach the chosen target.