Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework? （）A、SQL statements that are part of the AWR baseline only B、SQL statements based on the AWR top SQL identificationC、SQL statements that are part of the available

题目

Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework? （）

  • A、SQL statements that are part of the AWR baseline only 
  • B、SQL statements based on the AWR top SQL identification
  • C、SQL statements that are part of the available SQL Tuning Set (STS) only 
  • D、SQL statements that are available in the cursor cache and executed by a user other than SYS 
相似考题

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

2.Which three statements about performance analysis by SQL Performance Analyzer are true? ()(Choose three.)A. It detects changes in SQL execution plans.B. It produces results that can be used to create the SQL plan baseline.C. The importance of SQL statements is based on the size of the objects accessed.D. It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.E. It shows only the overall impact on workload and not the net SQL impact on workload.

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

4.Which two statements about the SQL Management Base (SMB) are true?()A. It contains only SQL profiles generated by SQL Tuning Advisor.B. It stores plans generated by the optimizer using a stored outline.C. It is part of the data dictionary and stored in the SYSAUX tablespace.D. It is part of the data dictionary and stored in the SYSTEM tablespace.E. It contains the statement log, the plan history, plan baselines, and SQL profiles.

参考答案和解析
正确答案:B
更多“Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework? （）A、SQL statements that are part of the AWR baseline only B、SQL statements based on the AWR top SQL identificationC、SQL statements that are part of the available”相关问题

  • 第1题：

    Which two statements about the SQL Management Base (SMB) are true? （）(Choose two.)

    • A、It contains only SQL profiles generated by SQL Tuning Advisor.
    • B、It stores plans generated by the optimizer using a stored outline.
    • C、It is part of the data dictionary and stored in the SYSAUX tablespace.
    • D、It is part of the data dictionary and stored in the SYSTEM tablespace.
    • E、It contains the statement log, the plan history, plan baselines, and SQL profiles.

    正确答案:C,E

  • 第2题：

    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

  • 第3题：

    Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework？（）

    • A、 SQL statements that are part of the AWR baseline only
    • B、 SQL statements based on the AWR top SQL identification
    • C、 SQL statements that are part of the available SQL Tuning Set （STS） only
    • D、 SQL statements that are available in the cursor cache and executed by a user other than SYS

    正确答案:B

  • 第4题：

    Identify the activities performed as part of the Automatic SQL Tuning process in the maintenance window?（）

    • A、generating the SQL profile
    • B、testing and accepting the SQL profile
    • C、generating a list of candidate SQLs for tuning
    • D、adding tuned SQL plans into the SQL plan baseline
    • E、tuning each SQL statement in the order of importance
    • F、generating baselines that include candidate SQLs for tuning

    正确答案:A,B,C,E

  • 第5题：

    Which component does the SQL Tuning Advisor NOT analyze for the SQL statements？（）  

    • A、ADDM
    • B、AWR
    • C、Cursor Cache
    • D、SQL Tuning Sets
    • E、Flash Recovery Area

    正确答案:E

  • 第6题：

    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

  • 第7题：

    多选题
    Which three statements about performance analysis by SQL Performance Analyzer are true? （）(Choose three.)
    A

    It detects changes in SQL execution plans.

    B

    It produces results that can be used to create the SQL plan baseline.

    C

    The importance of SQL statements is based on the size of the objects accessed.

    D

    It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.

    E

    It shows only the overall impact on workload and not the net SQL impact on workload.


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

  • 第8题：

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

  • 第9题：

    单选题
    Which statement is true when you run the SQL Tuning Advisor with limited scope？（）
    A

    Access path analysis is not performed for the SQL statements.

    B

    SQL structure analysis is not performed for the SQL statements.

    C

    SQL Profile recommendations are not generated for the SQL statements.

    D

    The staleness and absence of the statistics are not checked for the objects in the query supplied to the SQL Tuning Advisor.


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

  • 第10题：

    单选题
    Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework？（）
    A

     SQL statements that are part of the AWR baseline only

    B

     SQL statements based on the AWR top SQL identification

    C

     SQL statements that are part of the available SQL Tuning Set （STS） only

    D

     SQL statements that are available in the cursor cache and executed by a user other than SYS


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

  • 第11题：

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

  • 第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 statement is true when you run the SQL Tuning Advisor with limited scope？（）

    • A、Access path analysis is not performed for the SQL statements.
    • B、SQL structure analysis is not performed for the SQL statements.
    • C、SQL Profile recommendations are not generated for the SQL statements.
    • D、The staleness and absence of the statistics are not checked for the objects in the query supplied to the SQL Tuning Advisor.

    正确答案:C

  • 第14题：

    What happens when you run the SQL Tuning Advisor with limited scope？（）  

    • A、 Access path analysis is not performed for SQL statements.
    • B、 SQL structure analysis is not performed for SQL statements.
    • C、 SQL Profile recommendations are not generated for SQL statements.
    • D、 Staleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor.

    正确答案:B

  • 第15题：

    What happens when you run the SQL Tuning Advisor with limited scope?（）

    • A、Access path analysis is not performed for SQL statements.
    • B、SQL structure analysis is not performed for SQL statements.
    • C、SQL Profile recommendations are not generated for SQL statements.
    • D、Staleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor. In this case, SQL Tuning Advisor produces recommendations based on statistical checks, access path analysis, and SQL structure analysis. SQL profile recommendations are not generated.

    正确答案:B,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 three statements about performance analysis by SQL Performance Analyzer are true？（）

    • A、 It detects changes in SQL execution plans.
    • B、 It produces results that can be used to create the SQL plan baseline.
    • C、 The importance of SQL statements is based on the size of the objects accessed.
    • D、 It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.
    • E、 It shows only the overall impact on workload and not the net SQL impact on workload.

    正确答案:A,B,D

  • 第18题：

    多选题
    Which two statements about the SQL Management Base (SMB) are true?（）
    A

    It contains only SQL profiles generated by SQL Tuning Advisor.

    B

    It stores plans generated by the optimizer using a stored outline.

    C

    It is part of the data dictionary and stored in the SYSAUX tablespace.

    D

    It is part of the data dictionary and stored in the SYSTEM tablespace.

    E

    It contains the statement log, the plan history, plan baselines, and SQL profiles.


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

  • 第19题：

    单选题
    What happens when you run the SQL Tuning Advisor with limited scope？（）
    A

     Access path analysis is not performed for SQL statements.

    B

     SQL structure analysis is not performed for SQL statements.

    C

     SQL Profile recommendations are not generated for SQL statements.

    D

     Staleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor.


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

  • 第20题：

    多选题
    Which two statements about the SQL Management Base (SMB) are true? （）(Choose two.)
    A

    It contains only SQL profiles generated by SQL Tuning Advisor.

    B

    It stores plans generated by the optimizer using a stored outline.

    C

    It is part of the data dictionary and stored in the SYSAUX tablespace.

    D

    It is part of the data dictionary and stored in the SYSTEM tablespace.

    E

    It contains the statement log, the plan history, plan baselines, and SQL profiles.


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

  • 第21题：

    单选题
    Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework? （）
    A

    SQL statements that are part of the AWR baseline only 

    B

    SQL statements based on the AWR top SQL identification

    C

    SQL statements that are part of the available SQL Tuning Set (STS) only 

    D

    SQL statements that are available in the cursor cache and executed by a user other than SYS 


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

  • 第22题：

    多选题
    What happens when you run the SQL Tuning Advisor with limited scope?（）
    A

    Access path analysis is not performed for SQL statements.

    B

    SQL structure analysis is not performed for SQL statements.

    C

    SQL Profile recommendations are not generated for SQL statements.

    D

    Staleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor. In this case, SQL Tuning Advisor produces recommendations based on statistical checks, access path analysis, and SQL structure analysis. SQL profile recommendations are not generated.


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

  • 第23题：

    多选题
    Which three statements about performance analysis by SQL Performance Analyzer are true？（）
    A

    It detects changes in SQL execution plans.

    B

    It produces results that can be used to create the SQL plan baseline.

    C

    The importance of SQL statements is based on the size of the objects accessed.

    D

    It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.

    E

    It shows only the overall impact on workload and not the net SQL impact on workload.


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

相关内容