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. ARCH writes data to which of the following data files?
Please select the best answer.
  A. Archive log files
  B. Redo log files
  C. Data files
  D. Control files

3. DBWR writes data to which of the following data 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 redo log files that must exist for an instance to start?
Please select the best answer.
  A. 0
  B. 1
  C. 2
  D. 3

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

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