Oracle Database Administration I — Question 113

Which two statements are true about the PMON background process? (Choose two.)

Answer options

• A. It registers database services with all local and remote listeners known to the database instance.
• B. It frees unused temporary segments.
• C. It rolls back transactions when a process fails.
• D. It records checkpoint information in the control file.
• E. It frees resources held by abnormally terminated processes.

Correct answer: A, E

Explanation

Option A is correct because PMON is responsible for registering database services with listeners. Option E is also correct as PMON cleans up resources associated with processes that have terminated abnormally. Options B, C, and D are incorrect as they pertain to different Oracle background processes: segment freeing is handled by other processes, transactions rollbacks are managed by the rollback segments, and checkpoint information is managed by the CKPT process.