RelationalDBDesign RelationalDBDesign


Tuning Instance   «Prev  Next»

Redo log basics - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 
1. Which Oracle server process moves redo logs from the online redo logs to the archived log directory?
Please select the best answer.
  A. LGWR
  B. ARCH
  C. RECO
  D. SMON

2. Which are true about redo log processing? (Please select all that apply.)
Please select all the correct answers.
  A. The LGWR process archives the redo log files into flat files for roll-forward capability.
  B. The log_buffer is the area of the SGA that holds redo log images.
  C. The archived redo log file system has frequent write activity and should ideally be on a separate disk.
  D. All Oracle databases will archive the redo log information.

3. Which is listed as an important redo log performance parameter for performance? (Please select all that apply.)
Please select all the correct answers.
  A. Log_buffer
  B. Log_archive_dest
  C. Log_archive_start
  D. Log_simultaneous_copies