nerdexam
Oracle

1Z0-052 · Question #135

Note the functionalities of various background processes: 1: Perform recovery at instance startup. 2: Free the resources used by a user process when it fails. 3: Cleanup the database buffer cache…

The correct answer is B. System Monitor (SMON): 1, 6. SMON is responsible for instance recovery at startup and reclaiming space from unused temporary segments, making option B the only correctly matched pairing.

Exploring the Oracle Database Architecture

Question

Note the functionalities of various background processes:

1: Perform recovery at instance startup. 2: Free the resources used by a user process when it fails. 3: Cleanup the database buffer cache when a process fails. 4: Dynamically register database services with listeners. 5: Monitor sessions for idle session timeout. 6: Cleanup unused temporary segments. 7: Record the checkpoint information in control file. Which option has the correct functionalities listed for a background process?

Options

  • ACheckpoint (CKPT): 1, 2, 5
  • BSystem Monitor (SMON): 1, 6
  • CProcess Monitor (PMON): 4, 6, 7
  • DDatabase Writer (DBWR): 1, 3, 4

How the community answered

(19 responses)
  • B
    95% (18)
  • D
    5% (1)

Why each option

SMON is responsible for instance recovery at startup and reclaiming space from unused temporary segments, making option B the only correctly matched pairing.

ACheckpoint (CKPT): 1, 2, 5

CKPT records checkpoint information in the control file and datafile headers (functionality 7); it does not perform instance recovery (1), free user process resources (2), or manage idle session timeouts (5).

BSystem Monitor (SMON): 1, 6Correct

SMON (System Monitor) performs automatic instance recovery when the database restarts after a crash by applying redo data to roll forward committed changes (functionality 1). SMON also periodically coalesces free space and cleans up unused temporary segments left by transactions that did not complete normally (functionality 6). Both responsibilities are core and exclusive to the SMON background process.

CProcess Monitor (PMON): 4, 6, 7

PMON handles freeing resources of failed user processes (2), dynamically registering database services with listeners (4), and monitoring idle session timeouts (5); temporary segment cleanup (6) belongs to SMON and checkpoint recording (7) belongs to CKPT.

DDatabase Writer (DBWR): 1, 3, 4

DBWR writes modified (dirty) blocks from the buffer cache to datafiles; it does not perform instance recovery (1), clean up the buffer cache on process failure (3 - that is PMON's role), or register services with listeners (4).

Concept tested: Oracle background process roles - SMON PMON CKPT DBWR

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/process-architecture.html

Topics

#SMON#PMON#CKPT#background processes

Community Discussion

No community discussion yet for this question.

Full 1Z0-052 Practice