Memory Processes   «Prev  Next»

LGWR, ARCH and DBWR - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. LGWR writes data to which of the following files?
Please select the best answer.
  A. Archive log files
  B. Redo log files
  C. Data files
  D. Control files

2. ARCn writes data to which of the following files?
Please select the best answer.
  A. Archive log files
  B. Redo log files
  C. Data files
  D. Control files

3. DBW writes data to which of the following files?
Please select the best answer.
  A. Archive log files
  B. Redo log files
  C. Data files
  D. Control files

4. What is the minimum number of online redo log groups that must exist for a database to open?
Please select the best answer.
  A. 0
  B. 1
  C. 2
  D. 3

5. ARCn reads information from which of the following structure(s)?
Please select the best answer.
  A. Redo log buffers
  B. Data files
  C. Database buffer cache
  D. Redo log files

6. When your application inserts data and sends a commit, which of the following is true?
Please select the best answer.
  A. Information is stored in the database buffer cache.
  B. DBW immediately flushes your committed data to disk.
  C. LGWR forces a log switch.
  D. CKPT is initiated and forces a checkpoint.