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.
You need to restart the database so that parameter changes can come into effect.
C.
The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.
D.
The parameter value would be changed and it would come into effect immediately.