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.
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.
相关考题：
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.
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
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
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
Your database supports a DSS workload that involves the execution of complex queries: Currently, the library cache contains the ideal workload for analysis. You want to analyze some of the queries for an application that are cached in the library cache.What must you do to receive recommendations about the efficient use of indexes and materialized views to improve query performance?（）A. Create a SQL Tuning Set (STS) that contains the queries cached in the library cache and run the SQL Tuning Advisor (STA) on the workload captured in the STS.B. Run the Automatic Workload Repository Monitor (ADDM).C. Create an STS that contains the queries cached in the library cache and run the SQL Performance Analyzer (SPA) on the workload captured in the STS.D. Create an STS that contains the queries cached in the library cache and run the SQL Access Advisor on the workload captured in the STS.
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
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.
What happens when you run the SQL Tuning Advisor with limited scope?（）A、Access pathanalysis 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.
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 AdvisorB、 EM Database home page，Software and Support，Advisor Central，SQL Advisors，Automatic SQL Tuning AdvisorC、 EM Database home page，Software and Support，Support Workbench，Advisor Central，SQL Advisors，Automatic SQL Tuning AdvisorD、 Either B or CE、 All of the above
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、 DBMS_WORKLOAD_REPOSITORYB、 DBMS_RESOURCE_MANAGERC、 DBMS_SQLTUNED、 DBMS_ADVISOR
Which of the following advisors is run in every maintenance window by the auto-task system?（）A、The Memory AdvisorB、The SQL Tuning AdvisorC、The Undo AdvisorD、The SQL Access Advisor
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 AdvisorB、run SQL Tuning Advisor on top SQL statementsC、run the Automatic Workload Repository （AWR） reportD、run the Automatic Database Diagnostic Monitor （ADDM）on top SQL statements
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 ResultsC、 From Advisor Central，choose SQL Advisors，Manual SQL Tuning Advisors，Tuning Task ResultsD、 Either B or C
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 SQLB、snapshotsC、SQL Tuning setsD、index access pathE、optimizer statisticsF、materialized view logs
You need to make structural changes to the cube. You also need to ensure that appropriate aggregations are created after the changes are made. What should you do?（）A、Record a weeks user activity by using SQL Profiler. Apply structural changes. Replay the activity and then run the Usage Based Optimization Wizard.B、Apply structural changes. Run the Database Engine Tuning Advisor.C、Apply structural changes. Run the Usage Based Optimization Wizard.D、Record a weeks user activity by using SQL Profiler. Apply structural changes. Run the Database Engine Tuning Advisor.
单选题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
单选题Which statement is true when you run the SQL Tuning Advisor with limited scope？（）AAccess path analysis is not performed for the SQL statements.BSQL structure analysis is not performed for the SQL statements.CSQL Profile recommendations are not generated for the SQL statements.DThe staleness and absence of the statistics are not checked for the objects in the query supplied to the SQL Tuning Advisor.
单选题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 DBMS_WORKLOAD_REPOSITORYB DBMS_RESOURCE_MANAGERC DBMS_SQLTUNED DBMS_ADVISOR
单选题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?（）Astatistics recommendationsBSQL Profile recommendationsCIndex-related recommendationsDrestructuring of SQL recommendations
单选题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?（）Astatistics recommendationsBSQL profile recommendationsCindex-related recommendationsDrestructuring of SQL recommendations
多选题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？ （）ATop SQLBsnapshotsCSQL Tuning setsDindex access pathEoptimizer statisticsFmaterialized view logs
单选题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 Advisor task, which sequence should you follow?（）AEM Database home page, Software and Support, SQL Advisors, Automatic SQL Tuning Advisor.BEM Database home page, Software and Support, Advisor Central, SQL Advisors, Automatic SQL Tuning Advisor.CEM Database home page, Software and Support, Support Workbench, Advisor Central, SQL Advisors, Automatic SQL Tuning Advisor.DEither B or CEAll of the above
单选题To view the results of a manual SQL Tuning Advisor task, which steps should the DBA take?（）AFrom the Advisor Central home page, select the tuning task from the Advisor Tasks section.BFrom Advisor Central, choose SQL Advisors, SQL Tuning Advisors, Manual Tuning Task Results.CFrom Advisor Central, choose SQL Advisors, Manual SQL Tuning Advisors, Tuning Task Results.DEither B or C
单选题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.
单选题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 AdvisorB EM Database home page，Software and Support，Advisor Central，SQL Advisors，Automatic SQL Tuning AdvisorC EM Database home page，Software and Support，Support Workbench，Advisor Central，SQL Advisors，Automatic SQL Tuning AdvisorD Either B or CE All of the above
多选题What happens when you run the SQL Tuning Advisor with limited scope?（）AAccess pathanalysis is not performed for SQL statements.BSQL structure analysis is not performed for SQL statements.CSQL Profile recommendations are not generated for SQL statements.DStaleness 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.
单选题You work with a newly created database. Presently， there is no application load on the database instance. You want to create a baseline for tuning the application， so you decide to collect recommendations that can be implemented to improve application performance. What action must you take to achieve this？（）A Run Segment AdvisorB Run the SQL Tuning Advisor （STA）C Run the Automatic Workload Repository （AWR） reportD Run the SQL Access Advisor with a hypothetical workload