1Z0-060
多选题Which three functions are performed by the SQL Tuning Advisor?（）ABuilding and implementing SQL profilesBRecommending the optimization of materialized viewsCChecking query objects for missing and stale statisticsDRecommending bitmap, function-based, and
题目
Building and implementing SQL profiles
Recommending the optimization of materialized views
Checking query objects for missing and stale statistics
Recommending bitmap, function-based, and B-tree indexes
Recommending the restructuring of SQL queries that are using bad plans
相似问题和答案
第1题：
A. It detects changes in SQL execution plans.
B. It produces results that can be used to create the SQL plan baseline.
C. The importance of SQL statements is based on the size of the objects accessed.
D. It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.
E. It shows only the overall impact on workload and not the net SQL impact on workload.
第2题：
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题：
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
第4题：
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.
正确答案:C
第5题：
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
正确答案:A,C,E
第6题：
A. selection of SQL plan baselines
B. partitioning of tables and indexes
C. creation of index-organized tables
D. creation of bitmap, function-based, and B-tree indexes
E. optimization of materialized views for maximum query usage and fast refresh
第7题：
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
正确答案:A,C,E
第8题：
A. selection of SQL plan baselines
B. partitioning of tables and indexes
C. creation of index-organized tables
D. creation of bitmap, function-based, and B-tree indexes
E. optimization of materialized views for maximum query usage and fast refresh
第9题：
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,C,D
第10题：
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