While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation?（）..

第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  

点击查看答案

第2题

[单选题] You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile?（）

A、The tuned plan is not added to the SQL plan baseline.  B、The tuned plan is added to the fixed SQL plan baseline as a fixed plan.  C、The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan.  D、The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.  

点击查看答案

第3题

[单选题] You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile?（）

A、The tuned plan is not added to the SQL plan baseline.  B、The tuned plan is added to the fixed SQL plan baseline as a fixed plan.  C、The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan.  D、The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.  

点击查看答案

第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  

点击查看答案

第5题

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

点击查看答案

第6题

[单选题] You are creating a SQL Tuning Set to allow a group of SQL statements to be passed into the SQL Tuning Advisor. Which packages will you use to create the SQL Tuning Set？（）

A、&ensp;DBMS_WORKLOAD_REPOSITORY  B、&ensp;DBMS_RESOURCE_MANAGER  C、&ensp;DBMS_SQLTUNE  D、&ensp;DBMS_ADVISOR  

点击查看答案

第7题

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

点击查看答案

第8题

[] To view the results of the most recent Automatic SQL Tuning Advisor task, which sequence should you follow?（）

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

点击查看答案

第9题

[单选题] While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation?（）

A、It updates the existing SQL profiles with current statistics.  B、It makes the statistics information available to GATHER_STATS_JOB  C、It initiates the statistics collection process by running GATHER_STATS_JOB  D、It logs a warning message in the alert log so that the DBA can perform statistics collection manually.  

点击查看答案

第10题

[单选题] While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation?（）

A、It updates the existing SQL profiles with current statistics.  B、It makes the statistics information available to GATHER_STATS_JOB  C、It initiates the statistics collection process by running GATHER_STATS_JOB  D、It logs a warning message in the alert log so that the DBA can perform statistics collection manually.  

点击查看答案

While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation?（）

请使用微信扫码支付