Multiple choice technology databases What is the default value for the OPTIMIZER_MODE initialization parameter? FIRST_ROWS ALL_ROWS CHOOSE COST Reveal answer Fill a bubble to check yourself C Correct answer Explanation The OPTIMIZER_MODE initialization parameter in Oracle defaults to CHOOSE. This setting allows the optimizer to choose between rule-based and cost-based optimization depending on whether statistics are available for the tables in the query.