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

Question

Options

• AIt determines the optimal table join order and method.
• BIt generates execution plans for SQL statements based on relevant schema objects, system and session parameters, and information found in the Data Dictionary.
• 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.

• A
  74% (39)
• B
  4% (2)
• C
  6% (3)
• E
  2% (1)
• F
  15% (8)

No community discussion yet for this question.