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. Which statement best describes how Oracle background processes perform their work?
Please select the best answer.
  A. All background processes execute in a fixed sequence.
  B. They work asynchronously in response to pending work, signals, or timer events, subject to operating system scheduling.
  C. Each background process must finish all its work before another can run.
  D. They run only when a user explicitly invokes them.

2. Which three options identify standard SGA components used to cache database blocks, share SQL-related information, and buffer redo entries?
Please select all the correct answers.
  A. Database buffer cache
  B. Private SQL work areas in the PGA
  C. Oracle executable files on disk
  D. Shared pool
  E. Redo log buffer
  F. Online redo log files

3. Which tasks are responsibilities of the System Monitor process (SMON)?
Please select all the correct answers.
  A. Performing instance recovery when required.
  B. Registering database services with the Oracle Net listener.
  C. Writing dirty database buffers to datafiles.
  D. Cleaning up unused temporary segments in permanent tablespaces.

4. Why does an Oracle instance use the System Global Area (SGA)?
Please select the best answer.
  A. To replace the physical datafiles with memory.
  B. To store all session-private data in a single shared area.
  C. To let server and background processes share cached data and instance control information efficiently.
  D. To eliminate the need to coordinate concurrent access.

5. Which statement correctly describes PMON and process cleanup in Oracle 26ai?
Please select the best answer.
  A. PMON writes dirty database blocks to datafiles.
  B. PMON detects abnormal process termination and delegates cleanup to CLMN, which can use CLnn helpers.
  C. PMON registers services with the listener and performs all cleanup itself.
  D. PMON stores redo entries in the shared pool.