DB Creation   «Prev  Next»

Oracle Log writer Process - Quiz

Select the best answer or answers for each question.
1. How many main LGWR processes does an Oracle database instance have, excluding any log writer worker processes?
Please select the best answer.
  A. Two
  B. One
  C. Ten
  D. Three

2. Which description best explains how LGWR writes redo from the redo log buffer?
Please select the best answer.
  A. It writes buffered redo entries not yet written, preserving the redo stream order.
  B. It always starts at the physical middle of the buffer.
  C. It writes only the newest redo entry and discards earlier unwritten entries.
  D. It selects redo entries randomly from anywhere in the buffer.

3. Where does LGWR write redo entries from the redo log buffer?
Please select the best answer.
  A. Archived redo log files
  B. Datafiles
  C. Online redo log files
  D. Control files