24题：choose one

Your database instance is started by using a server parameter file (SPFILE). You execute the following command to change the value of the LOG_BUFFER initialization parameter:

ALTER SYSTEM SET LOG_BUFFER=32M;

What is the outcome of this command?

A) The parameter value is changed and it comes into effect as soon as space becomes available in the SGA.

B) The parameter value is changed and it comes into effect at the next instance startup.

C) It returns an error because SCOPE should be set to MEMORY.

D) It returns an error because the value of this parameter cannot be changed dynamically.

Answer：D

(解析：这个参数是一个静态参数。来自3组：1015267481)