1.

What is the purpose of SMON background process?(a) Performs crash recovery when a failed instance starts up again(b) Performs recovery when a user process fails(c) Writes redo log entries to disk(d) None of the mentionedI had been asked this question in quiz.My question comes from Rapid Application Development in portion Database Programming Techniques of Database Management

Answer»

The correct choice is (a) PERFORMS CRASH RECOVERY when a failed instance starts up again

The EXPLANATION is: SMON (System MONITOR) is an Oracle background process created when you start a database instance.



Discussion

No Comment Found

Related InterviewSolutions