Oracle Database Administration II — Question 95

Which three are true about the Oracle Optimizer? (Choose three.)

Answer options

• A. It obeys all hints.
• B. It considers the filters in WHERE clauses when generating execution plans for SQL statements.
• C. It can re-optimize execution plans after previous executions detect suboptimal plans.
• D. It considers object statistics when generating execution plans for SQL statements.
• E. It updates stale object statistics in the Data Dictionary.
• F. It can only use SQL Plan Directives tied to the SQL statement for which a plan is being generated.

Correct answer: B, C, D

Explanation

The correct answers are B, C, and D because they accurately describe the Oracle Optimizer's behavior in considering WHERE clause filters, re-optimizing plans based on past performance, and taking object statistics into account. Options A, E, and F are incorrect as they either misrepresent the capabilities of the optimizer or state limitations that don't apply.