Oracle
1Z0-054 · Question #37
Which is the correct description of SQL profiling while using SQL Tuning Advisor?
The correct answer is B. It is auxiliary information collected by the optimizer for a SQL statement to eliminate estimation. See the full explanation below for the reasoning.
Question
Which is the correct description of SQL profiling while using SQL Tuning Advisor?
Options
- AIt is a set of recommendations by the optimizer to create new indexes.
- BIt is auxiliary information collected by the optimizer for a SQL statement to eliminate estimation
- CIt is a set of recommendations by the optimizer to refresh stale statistics to avoid bad execution
- DIt is a set of recommendations by the optimizer to restructure a SQL statement to avoid bad
How the community answered
(14 responses)- B86% (12)
- C7% (1)
- D7% (1)
Community Discussion
No community discussion yet for this question.