THE DEFAULT SCOPE OF ALTER SYSTEM IS BOTH MEMORY AND SPFILE

8. - OCA OCP ORACLE DATABASE 11G A LL IN ONE EXAM GUIDE P18 POTX
OCA OCP ORACLE DATABASE 11G A LL IN ONE EXAM GUIDE P18 POTX
8. þ B. The default scope of ALTER SYSTEM is both memory and spfile.ý A and C. A is wrong because this setting will have been replaced by the setting in the second command. C is wrong because the session-level setting will have been lost during the restart of the instance.