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

第1题：

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

第2题：

When creating a SQL tuning set，which of the following steps allows the DBA to reduce the size of the SQL set by selecting specific operators and values？（）

• A、 Filter versions
• B、 Filter loads
• C、 Filter tasks
• D、 Filter options

第3题：

第4题：

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.

第5题：

Which of the following cannot be used as input to the SQL Tuning Advisor?（） (Choose all that apply.)

• A、A single SQL statement provided by a user
• B、An existing SQL Tuning Set (STS)
• C、A preprocessed Database Replay workload
• D、A schema name
• E、SQL statement identified in EM as using excessive resources

第6题：

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.

第7题：

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.

第8题：

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 

第9题：

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

第10题：

You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing.  What information is captured as part of this process？（）

• A、 the SQL text
• B、 the execution plan
• C、 the execution context
• D、 the execution frequency
• E、 the system change number （SCN）