多选题Which statements are true regarding the concept of problems and incidents in the fault diagnosability infrastructure for Oracle Database 11g？（）AOnly the incident metadata and dumps are stored in the Automatic Diagnostic Repository （ADR）.BThe problem key is the same as the incident number.CThe database sends an incident alert to the Oracle Enterprise Manager Database Home page.DEvery problem has a problem key， which is a text string that describes the problem.EThe database makes an entry into the alert log file when problems and incidents occur.
多选题
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.
参考解析
解析：
暂无解析
相关考题：
View the Exhibit and note the contents of V$DIAG_INFO. Which statement is true about the ADR?() A. The text alert log file will be available in Diag TraceB. A copy alert log file will be kept in Diag Incident for every incident.C. The XML version of the alert log file will be available in Diag Trace.D. An Automatic Database Diagnostic Management (ADDM) report is generated and stored in the Health Monitor whenever an incident occurs.
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 FAILURED. The RECOVER command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURE command was executed
Which statements are true regarding the system－defined moving window baseline in Oracle Database 11g?() A. It does not allow you to change the moving window size.B. Adaptive threshold functionalities use it by default to compute statistics.C. It is created by default with the window size being equal to the AWR retention time.D. It is created when the first snapshot is collected by the Automatic Workload Repository (AWR).
Which setting enables the baselines by default in Oracle Database 11g?() A. setting the STATISTICS_LEVEL parameter to TYPICALB. adding filters to the Automatic Database Diagnostic Monitor (ADDM)C. enabling Automated Maintenance Task using Oracle Enterprise ManagerD. setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
Which statement is true regarding the retention policy for the incidents accumulated in the AutomaticDiagnostic Repository (ADR)?() A. The incident metadata is purged when the problem is resolved and the DBA closes the SRB.The incident files and dumps are not retained in the ADR for the manually created incidentsC. The incident files are retained but the incident metadata is purged when the problem is resolved and the DBA closes the SRD. 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
Which two statements are true about the Automatic Diagnostic Repository (ADR)?() (Choose two.) A. The ADR base keeps all diagnostic information in binary formatB. SQL*Plus provides the ADRI script, which can be used to work with ADRC. The ADR can be used for problem diagnosis only when the database is openD. The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to nullE. The ADR can be used for problem diagnosis even when the database instance is downF. The ADR base is shared across multiple instances
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.
Which two statements are true about the Automatic Diagnostic Repository （ADR）？（） A、 The ADR base keeps all diagnostic information in binary formatB、 SQL*Plus provides the ADRI script， which can be used to work with ADRC、 The ADR can be used for problem diagnosis only when the database is openD、 The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to nullE、 The ADR can be used for problem diagnosis even when the database instance is downF、 The ADR base is shared across multiple instances
Which statement is true for enabling Enterprise Manager Support Workbench in Oracle Database 11g to upload the physical files generated by Incident Packaging Service （IPS） to MetaLink？（）A、 The database must be running in ARCHIVELOG mode.B、 No special setup is required， and the feature is enabled by default.C、 The path for the Automatic Diagnostic Repository （ADR） must be configured with the DIAGNOSTIC_DEST initialization parameter.D、 The Enterprise Manager Support Workbench can be enabled only if the background process manage ability monitor （MMON） is configured.E、 Select the Enable option in the Oracle Configuration Manager Registration window during the installation of the Oracle Database 11g software， provide valid MetaLink credentials and select license agreement.
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.
You installed Oracle Database 11g afresh. Which statements are true regarding the default audit settings in this database？（） A、 The audit trail is stored in an operating system file.B、 Auditing is disabled for all privileges.C、 The audit trail is stored in the database.D、 Auditing is enabled for all privileges.E、 Auditing is enabled for certain privileges related to database security.
Which setting enables the baselines by default in Oracle Database 11g？（） A、 setting the STATISTICS_LEVEL parameter to TYPICALB、 adding filters to the Automatic Database Diagnostic Monitor （ADDM）C、 enabling Automated Maintenance Task using Oracle Enterprise ManagerD、 setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
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 SRB、 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 SRD、 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
Which statement is true regarding the retention policy for the incidents accumulated in the AutomaticDiagnostic Repository (ADR)?（）A、The incident metadata is purged when the problem is resolved and the DBA closes the SRB、The incident files and dumps are not retained in the ADR for the manually created incidentsC、The incident files are retained but the incident metadata is purged when the problem is resolved and the DBA closes the SRD、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
Which two statements are true about the Automatic Diagnostic Repository (ADR)?（） (Choose two.)A、The ADR base keeps all diagnostic information in binary formatB、SQL*Plus provides the ADRI script, which can be used to work with ADRC、The ADR can be used for problem diagnosis only when the database is openD、The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to nullE、The ADR can be used for problem diagnosis even when the database instance is downF、The ADR base is shared across multiple instances
Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g？（）A、 It does not allow you to change the moving window size.B、 Adaptive threshold functionalities use it by default to compute statistics.C、 It is created by default with the window size being equal to the AWR retention time.D、 It is created when the first snapshot is collected by the Automatic Workload Repository （AWR）.
Observe the following warning in an RMAN session of your database instance: WARNING: new failures were found since last LIST FAILURE command Which 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 FAILURED、The RECOVER command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURE command was executed
Observe the following warning in an RMAN session of your database instance： WARNING:// new failures were found since last LIST FAILURE command Which 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 FAILURED、 The RECOVER command has detected new failures recorded in the Automatic Diagnostic Repository （ADR） since the last LIST FAILURE command was executed
多选题Which statements are true regarding the creation of an incident package file by using the EM Workbench Support？（）AYou can add or remove the trace files to the package.BYou can create the incremental incident package ZIP file for new or modified diagnostic information for the incident package already created.CYou can add SQL test cases to the incident package.DYou cannot create an incremental incident package when the physical files are purged rom the ADR.
单选题Which setting enables the baselines by default in Oracle Database 11g？（）A setting the STATISTICS_LEVEL parameter to TYPICALB adding filters to the Automatic Database Diagnostic Monitor （ADDM）C enabling Automated Maintenance Task using Oracle Enterprise ManagerD setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
多选题You installed Oracle Database 11g afresh. Which statements are true regarding the default audit settings in this database？（）AThe audit trail is stored in an operating system file.BAuditing is disabled for all privileges.CThe audit trail is stored in the database.DAuditing is enabled for all privileges.EAuditing is enabled for certain privileges related to database security.
多选题Which two statements are true about the Automatic Database Diagnostic Monitor （ADDM）（）AThe ADDM requires at least four AWR snapshots for analysis.BThe ADDM runs after each AWR snapshot is collected automatically by MMON.CThe results of the ADDM analysis are stored in the Automatic Workload Repository （AWR）.DThe ADDM analysis provides only diagnostic information but does not provide recommendations.EThe ADDM calls other advisors if required， but does not provide recommendations about the advisors.
单选题Observe the following warning in an RMAN session of your database instance: WARNING: new failures were found since last LIST FAILURE command Which statement describes the scenario that must have produced this warning?（）AThe CHANGE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository(ADR)BThe VALIDATE DATABASE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR)CThe ADVISE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILUREDThe RECOVER command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURE command was executed
单选题Observe the following warning in an RMAN session of your database instance： WARNING:// new failures were found since last LIST FAILURE command Which 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 FAILURED The RECOVER command has detected new failures recorded in the Automatic Diagnostic Repository （ADR） since the last LIST FAILURE command was executed
多选题Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g?（）AIt does not allow you to change the moving window size.BAdaptive threshold functionalities use it by default to compute statistics.CIt is created by default with the window size being equal to the AWR retention time.DIt is created when the first snapshot is collected by the Automatic Workload Repository (AWR).
多选题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 diagnosis only when the database is openDThe ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to nullEThe ADR can be used for problem diagnosis even when the database instance is downFThe ADR base is shared across multiple instances
单选题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 SRB 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 SRD 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