Oracle
1Z0-082 · Question #97
Which three are true about the Oracle Optimizer? (Choose three.)
The correct answer is A. It determines the optimal table join order and method. B. It generates execution plans for SQL statements based on relevant schema objects, system and C. It can optimize only SELECT statements. See the full explanation below for the reasoning.
Manage Performance
Question
Which three are true about the Oracle Optimizer? (Choose three.)
Options
- AIt determines the optimal table join order and method.
- BIt generates execution plans for SQL statements based on relevant schema objects, system and
- CIt can optimize only SELECT statements.
- DIt will only generate SQL Plan Directives specific to a given SQL statement.
- EIt can re-optimize execution plans after previous executions detect suboptimal plans.
- FIt updates stale object statistics in the Data Dictionary.
How the community answered
(45 responses)- A73% (33)
- D7% (3)
- E16% (7)
- F4% (2)
Topics
#query optimizer#execution plans#SQL Plan Directives#statistics
Community Discussion
No community discussion yet for this question.