1Z0-060 · Question #9
Which three functions are performed by the SQL Tuning Advisor?
The correct answer is A. Building and implementing SQL profiles C. Checking query objects for missing and stale statistics E. Recommending the restructuring of SQL queries that are using bad plans. The SQL Tuning Advisor takes one or more SQL statements as an input and invokes the Automatic Tuning Optimizer to perform SQL tuning on the statements. The output of the SQL Tuning Advisor is in the form of an advice or recommendations, along with a rationale for…
Question
Which three functions are performed by the SQL Tuning Advisor?
Options
- ABuilding and implementing SQL profiles
- BRecommending the optimization of materialized views
- CChecking query objects for missing and stale statistics
- DRecommending bitmap, function-based, and B-tree indexes
- ERecommending the restructuring of SQL queries that are using bad plans
How the community answered
(26 responses)- A88% (23)
- B4% (1)
- D8% (2)
Explanation
The SQL Tuning Advisor takes one or more SQL statements as an input and invokes the Automatic Tuning Optimizer to perform SQL tuning on the statements. The output of the SQL Tuning Advisor is in the form of an advice or recommendations, along with a rationale for eachrecommendation and its expected benefit. The recommendation relates to collection of statistics on objects(C), creation of new indexes, restructuring of the SQL statement(E), or creation of a SQL profile(A). You can choose to accept the recommendation to complete the tuning of the SQL statements.
Topics
Community Discussion
No community discussion yet for this question.