Which option has the correct functionalities listed for a background process?

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?

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?

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



Leave a Reply 0

Your email address will not be published. Required fields are marked *