WHAT WILL BE THE SETTING OF THE OPTIMIZER_MODE PARAMETER FOR YOUR SESSION AFTER THE NEXT STARTUP IF YOU ISSUE THESE COMMANDS

OCA OCP ORACLE DATABASE 11G A LL IN ONE EXAM GUIDE P18 POTX

8. What will be the setting of the OPTIMIZER_MODE parameter for your session after the next startup if you issue these commands:

alter system set optimizer_mode=all_rows scope=spfile;

alter system set optimizer_mode=rule;

alter session set optimizer_mode=first_rows;

A. all_rows B. rule C. first_rows(Choose the best answer.)