Multiple choice technology databases

An Oracle instance is executing in a nondistributed configuration. The instance fails because of an operating system failure. Which background process would perform the instance recovery when the atabase is reopened ?

  1. PMON

  2. SMON

  3. RECO

  4. ARCn

  5. CKPT

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

SMON (System Monitor) performs instance recovery after a crash, including rolling forward uncommitted changes and rolling back uncommitted transactions. PMON (Process Monitor) cleans up failed processes. RECO handles distributed transaction recovery. ARCn archives redo logs. CKPT (Checkpoint) updates file headers to checkpoint position.