OCP 11G认证考试
多选题Which two statements are true about the Automatic Diagnostic Repository (ADR)?（）AThe ADR base keeps all diagnostic information in binary formatBSQL*Plus provides the ADRI script, which can be used to work with ADRCThe ADR can be used for problem diagno
题目
The ADR base keeps all diagnostic information in binary format
SQL*Plus provides the ADRI script, which can be used to work with ADR
The ADR can be used for problem diagnosis only when the database is open
The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to null
The ADR can be used for problem diagnosis even when the database instance is down
The ADR base is shared across multiple instances
相似问题和答案
第1题：
A. The ADR base keeps all diagnostic information in binary format
B. SQL*Plus provides the ADRI script, which can be used to work with ADR
C. The ADR can be used for problem diagnosis only when the database is open
D. The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to null
E. The ADR can be used for problem diagnosis even when the database instance is down
F. The ADR base is shared across multiple instances
第2题：
Which two statements about the Cisco Nexus 1000V VSM are true?（）
- A、It performs switching decisions and forwarding for the VEM
- B、It can be run on a virtual machine
- C、It can be used for remote VEM switching Iine cards
正确答案:B,C
第3题：
A. The ADR base keeps all diagnostic information in binary format
B. SQL*Plus provides the ADRI script, which can be used to work with ADR
C. The ADR can be used for problem diagnosis only when the database is open
D. The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to null
E. The ADR can be used for problem diagnosis even when the database instance is down
F. The ADR base is shared across multiple instances
第4题：
Which statements are true regarding the concept of problems and incidents in the fault diagnosability infrastructure for Oracle Database 11g？（）
- A、 Only the incident metadata and dumps are stored in the Automatic Diagnostic Repository （ADR）.
- B、 The problem key is the same as the incident number.
- C、 The database sends an incident alert to the Oracle Enterprise Manager Database Home page.
- D、 Every problem has a problem key， which is a text string that describes the problem.
- E、 The database makes an entry into the alert log file when problems and incidents occur.
正确答案:C,D,E
第5题：
Which two statements are true about the Automatic Diagnostic Repository （ADR）？（）
- A、 The ADR base keeps all diagnostic information in binary format
- B、 SQL*Plus provides the ADRI script， which can be used to work with ADR
- C、 The ADR can be used for problem diagnosis only when the database is open
- D、 The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to null
- E、 The ADR can be used for problem diagnosis even when the database instance is down
- F、 The ADR base is shared across multiple instances
正确答案:E,F
第6题：
Which two statements are true about the Automatic Database Diagnostic Monitor （ADDM）（）
- A、The ADDM requires at least four AWR snapshots for analysis.
- B、The ADDM runs after each AWR snapshot is collected automatically by MMON.
- C、The results of the ADDM analysis are stored in the Automatic Workload Repository （AWR）.
- D、The ADDM analysis provides only diagnostic information but does not provide recommendations.
- E、The ADDM calls other advisors if required， but does not provide recommendations about the advisors.
正确答案:B,C
第7题：
Which statements are true regarding the creation of an incident package file by using the EM Workbench Support？（）
- A、 You can add or remove the trace files to the package.
- B、 You can create the incremental incident package ZIP file for new or modified diagnostic information for the incident package already created.
- C、 You can add SQL test cases to the incident package.
- D、 You cannot create an incremental incident package when the physical files are purged rom the ADR.
正确答案:A,B,C
第8题：
Observe the following warning in an RMAN session of your database instance:WARNING: new failures were found since last LIST FAILURE commandWhich statement describes the scenario that must have produced this warning?（）
A. The CHANGE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository(ADR)
B. The VALIDATE DATABASE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR)
C. The ADVISE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURE
D. The RECOVER command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURE command was executed
第9题：
Which two statements are true about the Automatic Workload Repository （AWR）（）
- A、All AWR tables belong to the SYSTEM schema.
- B、The AWR contains systemwide tracing and logging information.
- C、The snapshots collected by the AWR are accessible through data dictionary views.
- D、The snapshots collected by the AWR are used by self-tuning components in the database.
正确答案:C,D
第10题：
Which statement is true regarding the retention policy for the incidents accumulated in the Automatic Diagnostic Repository （ADR）？（）
- A、 The incident metadata is purged when the problem is resolved and the DBA closes the SR
- B、 The incident files and dumps are not retained in the ADR for the manually created incidents
- C、 The incident files are retained but the incident metadata is purged when the problem is resolved and the DBA closes the SR
- D、 The default setting is for one year after which the incident metadata is purged from the ADR and the files are retained for one month
正确答案:D