多选题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

题目
多选题
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

相似考题

1.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

2.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

3.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.

4.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 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”相关问题

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

    Examine the following command; ALTER SYSTEM SET enable_ddl_logging = TRUE; Which statement is true?（）

    • A、Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.
    • B、All DDL commands are logged in the alert log file.
    • C、All DDL commands are logged in a different log file that contains DDL statements and their execution dates.
    • D、Only DDL commands that resulted in the creation of new segments are logged.
    • E、All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.

    正确答案:B

  • 第5题：

    Which two statements about Automatic Storage Management （ASM） are true？（）

    • A、ASM provides mirroring on file by file basis.
    • B、ASM provides automatic load balancing across all ASM disks.
    • C、ASM supports the Oracle database and operating system files.
    • D、ASM can be used to store trace files， alert log files， and the server parameter file （SPFILE）.

    正确答案:A,B

  • 第6题：

    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 FAILURE
    • D、 The RECOVER command has detected new failures recorded in the Automatic Diagnostic Repository （ADR） since the last LIST FAILURE command was executed

    正确答案:C

  • 第7题：

    多选题
    Which two statements about Automatic Storage Management （ASM） are true？（）
    A

    ASM provides mirroring on file by file basis.

    B

    ASM provides automatic load balancing across all ASM disks.

    C

    ASM supports the Oracle database and operating system files.

    D

    ASM can be used to store trace files， alert log files， and the server parameter file （SPFILE）.


    正确答案： D,C
    解析： 暂无解析

  • 第8题：

    多选题
    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.


    正确答案： A,C
    解析： 暂无解析

  • 第9题：

    单选题
    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 FAILURE

    D

     The RECOVER command has detected new failures recorded in the Automatic Diagnostic Repository （ADR） since the last LIST FAILURE command was executed


    正确答案： A
    解析： 暂无解析

  • 第10题：

    多选题
    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
    解析： 暂无解析

  • 第11题：

    单选题
    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 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
    解析： 暂无解析

  • 第12题：

    多选题
    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.


    正确答案： D,E
    解析： 暂无解析

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    Which two statements are true about the Automatic Diagnostic Repository (ADR)?（） (Choose two.)

    • 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

  • 第17题：

    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 FAILURE
    • D、The RECOVER command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURE command was executed

    正确答案:C

  • 第18题：

    多选题
    Which statements are true regarding the creation of an incident package file by using the EM WorkbenchSupport（）
    A

    You can add SQL test cases to the incident package.

    B

    You can add or remove the trace files to the package.

    C

    You cannot create an incremental incident package when the physical files are purged from the ADR.

    D

    You can create the incremental incident package ZIP file for new or modified diagnostic information for theincident package already created.


    正确答案： A,C
    解析： 暂无解析

  • 第19题：

    多选题
    Which two statements are true with regard to policy ordering? （）(Choose two.)
    A

    The last policy is the default policy, which allows all traffic.

    B

    The order of policies is not important.

    C

    New policies are placed at the end of the policy list.

    D

    The insert command can be used to change the order.


    正确答案： C,D
    解析： 暂无解析

  • 第20题：

    单选题
    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 FAILURE

    D

    The RECOVER command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURE command was executed


    正确答案： D
    解析： 暂无解析

  • 第21题：

    单选题
    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 manageability 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.


    正确答案： E
    解析： 暂无解析

  • 第22题：

    多选题
    Which two statements are true about the Automatic Diagnostic Repository (ADR)?（） (Choose two.)
    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


    正确答案： D,B
    解析： 暂无解析

  • 第23题：

    单选题
    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


    正确答案： C
    解析： 暂无解析

  • 第24题：

    多选题
    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
    解析： 暂无解析

相关内容