OCP 1Z0 053 140

140.Which two statements are true regarding Health Monitor checks in Oracle Database 11g? (Choose 
two.) 
A. Health Monitor checks can be used to scan the contents of the redo log and archive logs for 
accessibility and corruption. 
B. Health Monitor checks can be used to verify the integrity of database files and report failures if these 
files are inaccessible, corrupt or inconsistent. 
C. Health Monitor checks can be used to verify the contents of dictionary entries for each dictionary object 
and fix it automatically. 
D. Health Monitor checks are always initiated manually when there is some critical error. 
Answer: AB 

http://docs.oracle.com/cd/E11882_01/server.112/e25494/diag.htm#ADMIN11270

About Health Monitor

Beginning with Release 11g, Oracle Database includes a framework called Health Monitor for running diagnostic checks on the database.

About Health Monitor Checks

Health Monitor checks (also known as checkers, health checks, or checks) examine various layers and components of the database. Health checks detect file corruptions, physical and logical block corruptions, undo and redo corruptions, data dictionary corruptions, and more. The health checks generate reports of their findings and, in many cases, recommendations for resolving problems. Health checks can be run in two ways:

• Reactive—The fault diagnosability infrastructure can run health checks automatically in response to a critical error.

• Manual—As a DBA, you can manually run health checks using either the DBMS_HM PL/SQL package or the Enterprise Manager interface. You can run checkers on a regular basis if desired, or Oracle Support may ask you to run a checker while working with you on a service request.

Health Monitor checks store findings, recommendations, and other information in the Automatic Diagnostic Repository (ADR).

Health checks can run in two modes:

• DB-online mode means the check can be run while the database is open (that is, in OPEN mode or MOUNT mode).

• DB-offline mode means the check can be run when the instance is available but the database itself is closed (that is, in NOMOUNT mode).

All the health checks can be run in DB-online mode. Only the Redo Integrity Check and the DB Structure Integrity Check can be used in DB-offline mode.