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 when an Oracle instance restarts after a failure. In a nondistributed configuration, SMON rolls forward changes in the online redo log and rolls back uncommitted transactions to bring the database to a consistent state.