RelationalDBDesign RelationalDBDesign


Instance Architecture   «Prev  Next»

PMON, SMON, and the SGA - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 
1. Oracle background process execution is scheduled as follows:
Please select the best answer.
  A. Processes each take turns executing.
  B. Processes execute whenever they need to.
  C. Processes are executed in priority order.
  D. Processes execute when invoked by a user.

2. Identify the three major components of the System Global Area.
Please select all the correct answers.
  A. Database buffer cache
  B. Global SQL variables
  C. Oracle program code
  D. Shared pool
  E. Redo log buffer
  F. Database log buffer

3. Identify which of these tasks SMON is responsible for.
Please select all the correct answers.
  A. Crash recovery
  B. Monitoring of SQL statements
  C. Terminating user processes
  D. Coalescing of free space

4. Oraclei uses a shared memory area (the SGA) because:
Please select the best answer.
  A. It frees up more disk space for the datafiles.
  B. It is the only solution supported by the UNIX architecture.
  C. It is an efficient way to share data between processes.
  D. It needs to maintain compatibility with Oracle 6.