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

The correct answer is 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. The optimizer uses hints to choose an execution plan for the statement unless prevented by some condition. (not A) In automatic reoptimization, the optimizer changes a plan on subsequent executions after the initial execution. (C)

Manage Database Performance

Question

Options

AIt obeys all hints.
BIt considers the filters in WHERE clauses when generating execution plans for SQL statements.
CIt can re-optimize execution plans after previous executions detect suboptimal plans.
DIt considers object statistics when generating execution plans for SQL statements.
EIt updates stale object statistics in the Data Dictionary.
FIt can only use SQL Plan Directives tied to the SQL statement for which a plan is being

How the community answered

(46 responses)

A
2% (1)
B
83% (38)
E
7% (3)
F
9% (4)

Explanation

The optimizer uses hints to choose an execution plan for the statement unless prevented by some condition. (not A) In automatic reoptimization, the optimizer changes a plan on subsequent executions after the initial execution. (C)

Topics

#Oracle Optimizer#execution plans#SQL Plan Directives#optimizer statistics

Community Discussion

No community discussion yet for this question.

Full 1Z0-083 Practice