17. 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: Clean up 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?
A.Checkpoint (CKPT): 1, 2, 5
B.System Monitor (SMON): 1, 6
C.Process Monitor (PMON): 4, 6, 7
D.Database Writer (DBWR): 1, 3, 4
Answer: B
1: Perform recovery at instance startup.
2: Free the resources used by a user process when it fails.
3: Clean up 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?
A.Checkpoint (CKPT): 1, 2, 5
B.System Monitor (SMON): 1, 6
C.Process Monitor (PMON): 4, 6, 7
D.Database Writer (DBWR): 1, 3, 4
Answer: B
The checkpoint process (CKPT) updates the control file and data file headers with checkpoint information and signals DBWnto write blocks to disk
1: Perform recovery at instance startup. (SMON)
2: Free the resources used by a user process when it fails. (PMON)
3: Clean up the database buffer cache when a process fails. (PMON)
4: Dynamically register database services with listeners. (PMON)
5: Monitor sessions for idle session timeout. (PMON)
6: Cleanup unused temporary segments. (SMON)
7: Record the checkpoint information in control file. (CKPT)
即使没有全记住,这个用排除法还是很容易的