Choose three.

Oracle 1z0-083 Question Answer

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

It considers the filters in WHERE clauses when generating execution plans for SQL statements.

It obeys all hints.

It considers object statistics when generating execution plans for SQL statements.

It updates stale object statistics in the Data Dictionary.

It can only use SQL Plan Directives tied to the SQL statement for which a plan is being generated.

It can re-optimize execution plans after previous executions detect suboptimal plans.

1z0-083 PDF/Engine

Get 65% Discount on All Products, Use Coupon: "ac4s65"