多选题Which tasks are run automatically as part of the Automated Maintenance Task by default?（）ASegment AdvisorBSQL Access AdvisorCOptimizer statistics gatheringDAutomatic SQL Tuning AdvisorEAutomatic Database Diagnostics Monitor

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

相似考题

1.The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?（）A. statistics recommendationsB. SQL Profile recommendationsC. Index-related recommendationsD. restructuring of SQL recommendations

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

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

4.The SQL Tuning Advisor has been configured with default configurations in your database instance.Which recommendation is automatically implemented without the DBA‘s intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?（）A. statistics recommendationsB. SQL profile recommendationsC. index-related recommendationsD. restructuring of SQL recommendations

参考答案和解析
正确答案： B,A
解析： 暂无解析
更多“多选题Which tasks are run automatically as part of the Automated Maintenance Task by default?（）ASegment AdvisorBSQL Access AdvisorCOptimizer statistics gatheringDAutomatic SQL Tuning AdvisorEAutomatic Database Diagnostics Monitor”相关问题

  • 第1题：

    The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task. What is the reason for this?()

    A. to prevent the creation of an excessive number of scheduler job classes

    B. to allow the Automated Maintenance Tasks to use system resources without any restriction

    C. to allow resource sharing only among the Automated Maintenance Tasks in the maintenance window

    D. to prevent the Automated Maintenance Tasks from consuming excessive amounts of system resources


    参考答案：D

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

    Which setting enables the baselines by default in Oracle Database 11g？（）  

    • A、 setting the STATISTICS_LEVEL parameter to TYPICAL
    • B、 adding filters to the Automatic Database Diagnostic Monitor （ADDM）
    • C、 enabling Automated Maintenance Task using Oracle Enterprise Manager
    • D、 setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE

    正确答案:A

  • 第5题：

    To view the results of a manual SQL Tuning Advisor task, which steps should the DBA take?（）

    • A、From the Advisor Central home page, select the tuning task from the Advisor Tasks section.
    • B、From Advisor Central, choose SQL Advisors, SQL Tuning Advisors, Manual Tuning Task Results.
    • C、From Advisor Central, choose SQL Advisors, Manual SQL Tuning Advisors, Tuning Task Results.
    • D、Either B or C

    正确答案:A

  • 第6题：

    Which of the following advisors is run in every maintenance window by the auto-task system?（）

    • A、The Memory Advisor
    • B、The SQL Tuning Advisor
    • C、The Undo Advisor
    • D、The SQL Access Advisor

    正确答案:B

  • 第7题：

    To view the results of a manual SQL Tuning Advisor task， which steps should the DBA take？（）  

    • A、 From the Advisor Central home page，select the tuning task from the Advisor Tasks section 
    • B、 From Advisor Central，choose SQL Advisors，SQL Tuning Advisors，Manual Tuning Task Results
    • C、 From Advisor Central，choose SQL Advisors，Manual SQL Tuning Advisors，Tuning Task Results
    • D、 Either B or C

    正确答案:A

  • 第8题：

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


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

  • 第9题：

    单选题
    The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?（）
    A

    statistics recommendations

    B

    SQL Profile recommendations

    C

    Index-related recommendations

    D

    restructuring of SQL recommendations


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

  • 第10题：

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


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

  • 第11题：

    多选题
    Which two statements are true with respect to the maintenance window？（） .
    A

    A DBA can enable or disable an individual task in all maintenance windows.

    B

    A DBA cannot change the duration of the maintenance window after it is created.

    C

    In case of a long maintenance window，all Automated Maintenance Tasks are restarted every four hours.

    D

    A DBA can control the percentage of the resource allocated to the Automated Maintenance Tasks in each window


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

  • 第12题：

    单选题
    The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA’s intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework？（）
    A

     statistics recommendations

    B

     SQL profile recommendations

    C

     index-related recommendations

    D

     restructuring of SQL recommendations


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

  • 第13题：

    Which of the following advisors is run in every maintenance window by the auto－task system?()

    A. The Memory Advisor

    B. The SQL Tuning Advisor

    C. The Undo Advisor

    D. The SQL Access Advisor


    参考答案：B

  • 第14题：

    The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA’s intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework？（）

    • A、 statistics recommendations
    • B、 SQL profile recommendations
    • C、 index-related recommendations
    • D、 restructuring of SQL recommendations

    正确答案:B

  • 第15题：

    The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task. What is the reason for this?（）

    • A、to prevent the creation of an excessive number of scheduler job classes
    • B、to allow the Automated Maintenance Tasks to use system resources without any restriction
    • C、to allow resource sharing only among the Automated Maintenance Tasks in the maintenance window
    • D、to prevent the Automated Maintenance Tasks from consuming excessive amounts of system resources

    正确答案:D

  • 第16题：

    The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?（）

    • A、statistics recommendations
    • B、SQL Profile recommendations
    • C、Index-related recommendations
    • D、restructuring of SQL recommendations

    正确答案:B

  • 第17题：

    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

  • 第18题：

    You received complaints about the degradation of SQL query performance. You identified top SQL queries that consume time. What would be your next step to find out recommendations about statistics collection and restructuring of the SQL statement to improve query performance？（）

    • A、run Segment Advisor
    • B、run SQL Tuning Advisor on top SQL statements
    • C、run the Automatic Workload Repository （AWR） report
    • D、run the Automatic Database Diagnostic Monitor （ADDM）on top SQL statements

    正确答案:B

  • 第19题：

    You are a database administrator for your company. You are configuring a new SQL Server 2005 computer named SQL1. SQL1 will run Reporting Services. It will also be configured to automatically perform database backups and other maintenance tasks. There are no other SQL Server computers in the network environment. All access to SQL1 will be made by using SQL1s DNS name. You need to disable any unnecessary services on SQL1. Which service or services should you disable？（）

    • A、Internet Information Services
    • B、SQL Server Browser
    • C、SQL Server Agent
    • D、Microsoft Distributed Transaction Coordinator

    正确答案:B,D

  • 第20题：

    单选题
    Which setting enables the baselines by default in Oracle Database 11g？（）
    A

     setting the STATISTICS_LEVEL parameter to TYPICAL

    B

     adding filters to the Automatic Database Diagnostic Monitor （ADDM）

    C

     enabling Automated Maintenance Task using Oracle Enterprise Manager

    D

     setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE


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

  • 第21题：

    单选题
    The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA's intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?（）
    A

    statistics recommendations

    B

    SQL profile recommendations

    C

    index-related recommendations

    D

    restructuring of SQL recommendations


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

  • 第22题：

    单选题
    Which tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature?（）
    A

    Segment Advisor

    B

    SQL Access Advisor

    C

    Undo Advisor

    D

    SQL Tuning Advisor


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

  • 第23题：

    单选题
    The SQL Tuning Advisor configuration has default settings in your database instance.  Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task？（）
    A

     statistics recommendations

    B

     SQL Profile recommendations

    C

     Index-related recommendations

    D

     restructuring of SQL recommendations


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

  • 第24题：

    多选题
    You are a database administrator for your company. You are configuring a new SQL Server 2005 computer named SQL1. SQL1 will run Reporting Services. It will also be configured to automatically perform database backups and other maintenance tasks. There are no other SQL Server computers in the network environment. All access to SQL1 will be made by using SQL1s DNS name. You need to disable any unnecessary services on SQL1. Which service or services should you disable？（）
    A

    Internet Information Services

    B

    SQL Server Browser

    C

    SQL Server Agent

    D

    Microsoft Distributed Transaction Coordinator


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

相关内容