单选题To view the results of the most recent Automatic SQL Tuning Advisor task，which sequence should you follow？（）AEM Database home page，Software and Support，SQL Advisors，Automatic SQL Tuning AdvisorBEM Database home page，Software and Support，Advisor Central

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

相似考题

1.View the Exhibit to examine the Automatic SQL Tuning result details.Which action would you suggest for the selected SQL statement in the Exhibit?()A. Accept the recommended SQL profile.B.Collect statistics for the related objects.C. Run the Access Advisor for the SQL statement.D. Run the Segment Advisor for recommendations.

2.Identify the activities performed as part of the Automatic SQL Tuning process in the maintenance window?()A. generating the SQL profileB. testing and accepting the SQL profileC. generating a list of candidate SQLs for tuningD. adding tuned SQL plans into the SQL plan baselineE. tuning each SQL statement in the order of importanceF. generating baselines that include candidate SQLs for tuning

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

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

更多“To view the results of the most recent Automatic SQL Tuning ”相关问题

  • 第1题：

    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

  • 第2题：

    Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines.()

    A. Cursor cache

    B. Stored outline

    C. SQL Tuning Set

    D. Automatic Workload Repository (AWR) snapshots


    参考答案：A, C

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

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

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

    Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines.（）

    • A、Cursor cache
    • B、Stored outline
    • C、SQL Tuning Set
    • D、Automatic Workload Repository (AWR) snapshots

    正确答案:A,C

  • 第7题：

    You want to use the SQL Tuning Advisor to generate recommendations for badly written SQL statements in your development environment.   Which three sources can you select for the advisor to analyze？ （）

    • A、Top SQL
    • B、snapshots
    • C、SQL Tuning sets
    • D、index access path
    • E、optimizer statistics
    • F、materialized view logs

    正确答案:A,B,C

  • 第8题：

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


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

  • 第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 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
    解析： 暂无解析

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

    单选题
    When tuning Automatic PGA Memory Management， which of the following views will provide the information specified？（）
    A

     The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGET

    B

     The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will change if you change the value of PGA_AGGREGATE_TARGET

    C

     The V$PGA_TARGET_ADVICE_HISTOGRAM view shows how the V$SQL_WORKAREA_HISTOGRAM will change if you switch between Manual and Automatic PGA Memory Management

    D

     The V$PGA_TARGET_ADVICE view shows how performance will improve for the different work areas if you switch from Manual to Automatic PGA Memory Management


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

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

    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

  • 第15题：

    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

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

    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

  • 第18题：

    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

  • 第19题：

    单选题
    You work in a data warehouse environment that involves the execution of complex queries. The current content of the SQL cache holds the ideal workload for analysis. You want to analyze only few most resource-intensive statements. What would be your suggestion to receive recommendations on the efficient use of indexes and materialized views to improve query performance？（）
    A

    Run the SQL Access Advisor.

    B

    Run the SQL Tuning Advisor （STA）.

    C

    Run the Automatic Workload Repository （AWR） report.

    D

    Run the Automatic Database Diagnostic Monitor （ADDM）.


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

  • 第20题：

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

  • 第21题：

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

  • 第22题：

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


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

  • 第23题：

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

  • 第24题：

    多选题
    Which three tasks can be automatically performed by the Automatic Data Optimization feature ofInformation lifecycle Management (ILM)?（）
    A

    Tracking the most recent read time for a table segment in a user tablespace

    B

    Tracking the most recent write time for a table segment in a user tablespace

    C

    Tracking insert time by row for table rows

    D

    Tracking the most recent write time for a table block

    E

    Tracking the most recent read time for a table segment in the SYSAUX tablespace

    F

    Tracking the most recent write time for a table segment in the SYSAUX tablespace


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

相关内容