Your database is started by using the server parameter file (SPFILE). You issued this command to change the value of the LOG_BUFFER initialization parameter:  ALTER SYSTEM SET LOG_BUFFER=24M SCOPE=BOTH;  What would be the outcome of this command? ()
A:The command would return an error because LOG_BUFFER is a static parameter.
B:The parameter value would be changed and it would come into effect immediately.
C:You need to restart the database so that parameter changes can come into effect.
D:The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.
出自:Oracle认证