The Automatic Database Diagnostic Monitor (ADDM) analysis runs every 60 minutes on your database. Your database is facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a time span of tw

题目

The Automatic Database Diagnostic Monitor (ADDM) analysis runs every 60 minutes on your database. Your database is facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a time span of two hours in future. What would you do?（）

  • A、Create two custom ADDM tasks.
  • B、Modify the AWR snapshot time interval to two hours.
  • C、Create a new scheduler window for a time period of two hours.
  • D、Modify the Automatic Workload Repository (AWR) snapshot retention period to two hours.
相似考题

1.Which tasks are run automatically as part of the Automated Maintenance Task by default?()A. Segment AdvisorB. SQL Access AdvisorC. Optimizer statistics gatheringD. Automatic SQL Tuning AdvisorE. Automatic Database Diagnostics Monitor

2.Which background process of a database instance, using Automatic Storage Management (ASM), connects as a foreground process into the ASM instance?（）A、ASMBB、PMONC、RBALD、SMON

3.The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings， workload profile，and statistics to diagnose the possible causes of the performance degradation？（）A、by using the SQL access advisorB、by using the Automatic Workload Repository reportC、by running the Automatic Database Diagnostic Monitor （ADDM）D、by using the Automatic Workload Repository Compare Period reportE、by analyzing the output of the V$ACTIVE_SESSION_HISTORY view

4.Which tasks are run automatically as part of the Automated Maintenance Task by default? ()(Choose all that apply.)A. Segment AdvisorB. SQL Access AdvisorC. Optimizer statistics gatheringD. Automatic SQL Tuning AdvisorE. Automatic Database Diagnostics Monitor

参考答案和解析
正确答案:B
更多“The Automatic Database Diagnosti”相关问题

  • 第1题：

    What are the consequences of executing the SHUTDOWN ABORT command？ （）

    • A、The database files are synchronized.
    • B、Uncommitted changes are not rolled back.
    • C、The database is closed， but the instance is still started.
    • D、Database buffers and redo buffers are not written to the disk.
    • E、The database undergoes automatic media recovery during the next startup.

    正确答案:B,D

  • 第2题：

    You use the Memory Advisor to tune the memory structures of your database. What is the prerequisite to use the Memory Advisor？（）

    • A、 The database must be in the ARCHIVELOG mode.
    • B、 The automatic memory tuning must be enabled.
    • C、 The change tracking feature must be enabled.
    • D、 The automatic memory tuning must be disabled.

    正确答案:D

  • 第3题：

    You are enabling the Automatic Shared Memory Management feature in the Oracle Database 10g to ensure that the important memory structures of the System Global Area （SGA） are automatically adjusted depending on the database workload. You are using Enterprise Manager 10g to enable this feature. You are currently on the Administration tab page.  Which two links should you click to go to the Memory Advisor page？（）

    • A、 Advisor Central
    • B、 Global Attributes
    • C、 Resource Monitors
    • D、 Memory Parameters
    • E、 Database Usage Statistics
    • F、 All Initialization Parameters
    • G、 Automatic Workload Repository

    正确答案:A,C

  • 第4题：

    For Oracle 11g， Oracle strongly recommends that you configure your database to use which of the following memory-management features？（）  

    • A、 Automatic PGA Memory Management
    • B、 Automatic SGA Memory Management
    • C、 Automatic Shared Memory Management
    • D、 Automatic Memory Management
    • E、 Manual SGA Memory Management
    • F、 None of the above

    正确答案:D

  • 第5题：

    To view the results of the most recent Automatic SQL Tuning Advisor task，which sequence should you follow？（）  

    • A、 EM Database home page，Software and Support，SQL Advisors，Automatic SQL Tuning Advisor
    • B、 EM Database home page，Software and Support，Advisor Central，SQL Advisors，Automatic SQL Tuning Advisor
    • C、 EM Database home page，Software and Support，Support Workbench，Advisor Central，SQL Advisors，Automatic SQL Tuning Advisor
    • D、 Either B or C
    • E、 All of the above

    正确答案:D

  • 第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题：

    单选题
    You use the Memory Advisor to tune the memory structures of your database. What is the prerequisite to use the Memory Advisor？（）
    A

     The database must be in the ARCHIVELOG mode.

    B

     The automatic memory tuning must be enabled.

    C

     The change tracking feature must be enabled.

    D

     The automatic memory tuning must be disabled.


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

  • 第8题：

    单选题
    Which of the following would you use to enable automatic media recovery for a database？（）
    A

    SET AUTORECOVERY ON

    B

    SET RECOVERY ON

    C

    SET AUTO ON

    D

    You cannot enable automatic media recovery.


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

  • 第9题：

    单选题
    While setting up an Oracle database for one of your critical applications， you want to ensure that the database is backed up at regular intervals without your intervention.What should you do to achieve the objective？（）
    A

    configure the database to run in ARCHIVELOG mode

    B

    configure the Flash Recovery Area to enable automatic database backup

    C

    schedule the database backup using DBMS_JOB package after creating the database

    D

    schedule the database backup using Recovery Manager （RMAN）commands after creating the database

    E

    schedule the database backup using Database Configuration Assistant （DBCA）while creating the database


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

  • 第10题：

    单选题
    You are working on a new Oracle Database 11g server， where only the software is installed and no database iscreated. You plan to create a database on this server using the Database Configuration Assistant （DBCA）.Some of the requirements set for your database creation task are： 1.Configure the database to operate in shared server mode. 2.Disable automatic maintenance tasks such as optimizer statistics collection. 3.Configure a naming method to help the remote user connect to the database instance. 4.Use Automatic Storage Management （ASM） for storing the database files. 5.Configure daily database backup to flash recovery area. 6.Configure Enterprise Manager Database Control to manage the database.  Which of these requirements can be met while creating the database（）
    A

    4 and 6

    B

    2，3，4，and 6

    C

    1，2，4，5，and 6

    D

    1，2，3，4，5，and 6


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

  • 第11题：

    单选题
    To view the results of the most recent Automatic SQL Tuning Advisor task，which sequence should you follow？（）
    A

     EM Database home page，Software and Support，SQL Advisors，Automatic SQL Tuning Advisor

    B

     EM Database home page，Software and Support，Advisor Central，SQL Advisors，Automatic SQL Tuning Advisor

    C

     EM Database home page，Software and Support，Support Workbench，Advisor Central，SQL Advisors，Automatic SQL Tuning Advisor

    D

     Either B or C

    E

     All of the above


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

  • 第12题：

    单选题
    For Oracle 11g， Oracle strongly recommends that you configure your database to use which of the following memory-management features？（）
    A

     Automatic PGA Memory Management

    B

     Automatic SGA Memory Management

    C

     Automatic Shared Memory Management

    D

     Automatic Memory Management

    E

     Manual SGA Memory Management

    F

     None of the above


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

  • 第13题：

    Which tasks are run automatically as part of the Automated Maintenance Task by default? （）(Choose all that apply.)

    • A、Segment Advisor
    • B、SQL Access Advisor
    • C、Optimizer statistics gathering
    • D、Automatic SQL Tuning Advisor
    • E、Automatic Database Diagnostics Monitor

    正确答案:A,C,D

  • 第14题：

    You are working on a new Oracle Database 11g server， where only the software is installed and nodatabase is created. You plan to create a database on this server using the Database Configuration Assistant （DBCA）.  Some of the requirements set for your database creation task are：  1：Configure the database to operate in shared server mode.  2：Disable automatic maintenance tasks such as optimizer statistics collection.  3：Configure a naming method to help the remote user connect to the database instance.  4：Use Automatic Storage Management （ASM） for storing the database files.  5：Configure daily database backup to flash recovery area.  6：Configure Enterprise Manager Database Control to manage the database.  Which of these requirements can be met while creating the database（）

    • A、4 and 6
    • B、2，3，4，and 6
    • C、1，2，4，5，and 6
    • D、1，2，3，4，5，and 6

    正确答案:C

  • 第15题：

    In an Oracle 10g database， the in-memory statistics are gathered at regular intervals and used to perform growth-trend analysis and capacity planning of the database. Which component stores these statistics？（） 

    • A、recovery catalog
    • B、Oracle Enterprise Manager Repository
    • C、Automatic Workload Repository （AWR）
    • D、Oracle 10g Enterprise Manager Grid Control
    • E、Automatic Database Diagnostic Monitor （ADDM）

    正确答案:C

  • 第16题：

    Which tasks are run automatically as part of the Automated Maintenance Task by default？（） 

    • A、 Segment Advisor
    • B、 SQL Access Advisor
    • C、 Optimizer statistics gathering
    • D、 Automatic SQL Tuning Advisor
    • E、 Automatic Database Diagnostics Monitor

    正确答案:A,C,D

  • 第17题：

    Which background process of a database instance, using Automatic Storage Management (ASM), connects asa foreground process into the ASM instance?（）

    • A、ASMB
    • B、PMON
    • C、RBAL
    • D、SMON

    正确答案:A

  • 第18题：

    Which statement is true about the Manageability Monitor （MMON） background process（）

    • A、It transfers statistics from memory to disk at regular intervals.
    • B、It coordinates the rebalance activity for disk groups when ASM is used.
    • C、It communicates with the Automatic Storage Management （ASM） instance on behalf of the database Instance.
    • D、It performs dynamic memory management when Automatic Shared Memory Management is enabled for the Database instance

    正确答案:A

  • 第19题：

    单选题
    You are working on a new Oracle Database 11g server， where only the software is installed and no database iscreated. You plan to create a database on this server using the Database Configuration Assistant （DBCA）.Some of the requirements set for your database creation task are： 1.Configure the database to operate in shared server mode. 2.Disable automatic maintenance tasks such as optimizer statistics collection. 3.Configure a naming method to help the remote user connect to the database instance. 4.Use Automatic Storage Management （ASM） for storing the database files. 5.Configure daily database backup to flash recovery area. 6.Configure Enterprise Manager Database Control to manage the database.  Which of these requirements can be met while creating the database（）
    A

    4 and 6

    B

    2，3，4，and 6

    C

    1，2，4，5，and 6

    D

    1，2，3，4，5，and 6


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

  • 第20题：

    单选题
    Examine the parameter setting in your database: Which statement is correct about the database?（）
    A

    Automatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET are not set

    B

    The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET and SGA_TARGET are set

    C

    The database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGET and SGA_TARGET are set

    D

    Automatic memory management is enabled and, as per policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startup


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

  • 第21题：

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

  • 第22题：

    单选题
    In an Oracle 10g database， the in-memory statistics are gathered at regular intervals and used to perform growth-trend analysis and capacity planning of the database. Which component stores these statistics？（）
    A

     Recovery catalog

    B

     Oracle Enterprise Manager Repository

    C

     Automatic Workload Repository （AWR）

    D

     Oracle 10g Enterprise Manager Grid Control

    E

     Automatic Database Diagnostic Monitor （ADDM）


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

  • 第23题：

    多选题
    What are the consequences of executing the SHUTDOWN ABORT command？ （）
    A

    The database files are synchronized.

    B

    Uncommitted changes are not rolled back.

    C

    The database is closed， but the instance is still started.

    D

    Database buffers and redo buffers are not written to the disk.

    E

    The database undergoes automatic media recovery during the next startup.


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

  • 第24题：

    单选题
    Which statement is true about the Manageability Monitor （MMON） background process（）
    A

    It transfers statistics from memory to disk at regular intervals.

    B

    It coordinates the rebalance activity for disk groups when ASM is used.

    C

    It communicates with the Automatic Storage Management （ASM） instance on behalf of the database Instance.

    D

    It performs dynamic memory management when Automatic Shared Memory Management is enabled for the Database instance


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

相关内容