Your database instance is started using the server parameter file (SPFILE). You executed a
command to change the value of the LOG_BUFFER initialization parameter: ALTER
SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH; What would be the outcome of this
command?
A.
The command succeeds, but you need to restart the database for changes to take
effect.
B.
The command returns an error because the size of the redo log buffer cannot be
changed dynamically.
C.
The parameter value is changed and it comes into effect as soon as space
becomes available in the System Global Area (SGA).
D.
The command succeeds only if Automatic Memory Management is not enabled.
B