Memory Architecture   «Prev  Next»

SGA Memory Structures - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. What is usually the largest structure in the SGA?
Please select the best answer.
  A. The database buffer cache
  B. The redo log buffer
  C. The shared pool
  D. The large pool

2. Which buffer pool is designed to retain frequently used blocks in memory for as long as the instance is running?
Please select the best answer.
  A. The permanent buffer pool
  B. The keep buffer pool
  C. The default buffer pool
  D. The pinned buffer pool

3. What two lists are used to organize the buffers in the database buffer cache?
Please select all the correct answers.
  A. The dirty list
  B. The MRU list
  C. The clean list
  D. The LRU list

4. The purpose of the redo log buffer is to:
Please select the best answer.
  A. Hold redo log entries in memory in case they need to be accessed again
  B. Hold redo log entries in memory just long enough to be written to disk
  C. Buffer redo log data as it is copied to the archive log files
  D. Provide space for Oracle to sort redo log entries before they are written

5. When a buffer in the database buffer cache is accessed, Oracle moves it to which end of the LRU list:
Please select the best answer.
  A. The least recently used end
  B. The most recently used end
  C. The frequently used end
  D. The buffer accessed end