单选题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 T
题目
单选题
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.