Which three are true about the Oracle Optimizer? (Choose three.) By Singh | January 7, 2023 0 Comment Which three are true about the Oracle Optimizer? (Choose three.) 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 session parameters, and information found in the Data Dictionary. C. It can re-optimize execution plans after previous executions detect suboptimal plans. D. It can optimize only SELECT statements. E. It will only generate SQL Plan Directives specific to a given SQL statement. F. It updates stale object statistics in the Data Dictionary. Correct Answer: A,B,D