Oracle Database 12c: Installation and Administration — Question 113

Which three are activities performed by SMON? (Choose three.)

Answer options

• A. cleaning up the database buffer cache and freeing resources that a client process was using
• B. applying online redo during instance recovery
• C. cleaning up temporary segments that are no longer needed
• D. performing database services registration with the default listener
• E. restarting a server or a dispatcher process that terminated abnormally
• F. recovering failed transactions that were skipped during instance recovery because of file-read or tablespace offline errors

Correct answer: B, C, F

Explanation

The correct answers, B, C, and F, are all functions performed by SMON related to instance recovery and cleanup tasks. Option A is incorrect as it relates to the database buffer cache, which is not SMON's responsibility. Option D is not a function of SMON; that is typically handled by another component, and option E pertains to process management, which is outside SMON's scope.