Oracle
1Z0-034 · Question #97
What happens when you run the SQL Tuning Advisor with limited scope?
The correct answer is C. SQL Profile recommendations are not generated for SQL statements. See the full explanation below for the reasoning.
Question
What happens when you run the SQL Tuning Advisor with limited scope?
Options
- AAccess path analysis is not performed for SQL statements.
- BSQL structure analysis is not performed for SQL statements.
- CSQL Profile recommendations are not generated for SQL statements.
- DStaleness and absence of statistics are not checked for the objects in the query supplied to the
How the community answered
(26 responses)- A4% (1)
- B8% (2)
- C73% (19)
- D15% (4)
Community Discussion
No community discussion yet for this question.