Memory Processes   «Prev  Next»

Memory Process Files - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. Which of the following processes write data from the SGA to disk?
Please select all the correct answers.
  A. User processes
  B. DBW
  C. ARCn
  D. SMON

2. Which of the following memory structures is required for the instance to start?
Please select all the correct answers.
  A. Data buffer cache
  B. Redo log buffers
  C. Large pool
  D. Shared pool

3. Which file structure records the changes needed to redo, or reapply, transactions during recovery?
Please select the best answer.
  A. Redo log files
  B. Control files
  C. Data files
  D. Parameter files

4. Which statement about Oracle's online redo log requirement is true?
Please select the best answer.
  A. An instance can open with just one online redo log group
  B. At least two online redo log groups are required so one is always available for writing
  C. Every redo log group must have multiplexed members for the database to open
  D. Online redo log groups are only required when the database runs in ARCHIVELOG mode