OCP考试第5题

Examine the section of the Health Check report given below:

检查如下的health check报告如下：

DBMS_HM.GET_RUN_REPORT('HM_RUN_1061')Run Name : HM_RUN_1061 Run Id : 1061 Check Name : Data Block Integrity Check Mode : REACTIVE Status : COMPLETED Start Time : 2007-05-12 22:11:02.032292 -07:00 End Time : 2007-05-12 22:11:20.835135 -07:00 Error Encountered : 0

Source Incident Id : 7418 Number of Incidents Created :0

Which two statements are true regarding the Health Check report? (Choose two.)

哪两个针对health check报告是正确的？

A. Health Check was performed manually.

手动检查

B. Health Check was performed to check the disk image block corruptions.

用来检查disk image block corruptions.

C. Health Check was performed to check interblock and intersegment corruption.

用来检查block和segment中间的损坏

D. Health Check was performed to verify(确认) the integrity(完整性) of database files and report failures.

用来检查数据文件的完整性并报告错误

E. Health Check was performed by the Health Monitor automatically in response to a critical(关键) error.

会被自动执行来应对关键错误

 

知识点：11g后，Health Monitor这个框架来运行health check。

health check包括detect file corruptions, physical and logical block corruptions, undo and redo corruptions, data dictionary corruptions，recommendations for resolving problems。 判断出B正确，CD错误。

两种方法执行：

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

Manual—As a DBA, you can manually run health checks using either the DBMS_HM PL/SQL package or the Enterprise Manager interface.        A正确。

两种模式：

DB-online   数据库mount/open

DB-offline   the instance is available but the database itself is closed (nomount)

 

答案：AB