多选题What recommendations does the SQL Access Advisor provide for optimizing SQL queries?（）Aselection of SQL plan baselinesBpartitioning of tables and indexesCcreation of index-organized tablesDcreation of bitmap, function-based, and B-tree indexesEoptimiza

第1题：

第2题：

Which three functions are performed by the SQL Tuning Advisor?（） (Choose three.)

• A、Building the SQL profile
• B、Recommending optimization of materialized views
• C、Checking query objects for missing and stale statistics
• D、Recommending bitmap, function-based, and B-tree indexes
• E、Recommending restructuring SQL queries that are using bad plans

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

第5题：

Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?（）

• A、SQL Repair Advisor
• B、SQL Optimizer
• C、SQL Access Advisor
• D、SQL Tuning Advisor

第6题：

第7题：

Which three functions are performed by the SQL Tuning Advisor?（）

• A、Building and implementing SQL profiles
• B、Recommending the optimization of materialized views
• C、Checking query objects for missing and stale statistics
• D、Recommending bitmap, function-based, and B-tree indexes
• E、Recommending the restructuring of SQL queries that are using bad plans

第8题：

第9题：

What two statements are true regarding the recommendations received from the SQL Access Advisor?（）(Choose two.)

• A、It cannot generate recommendations that support multiple workload queries.
• B、It can recommend partitioning on tables provided that the workloads have some predicates and joins on the columns of the NUMBER or DATE type.
• C、It can recommend partitioning only on tables that have at least 10,000 rows.
• D、It can recommend only B-tree indexes and not bitmap or function-based indexes

第10题：

Which three functions are performed by the SQL Tuning Advisor？（） 

• A、 Building the SQL profile
• B、 Recommending optimization of materialized views
• C、 Checking query objects for missing and stale statistics
• D、 Recommending bitmap， function-based， and B-tree indexes
• E、 Recommending restructuring SQL queries that are using bad plans