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:

SRE实战 互联网时代守护先锋，助力企业售后服务体系运筹帷幄！一键直达领取阿里云限量特价优惠。

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)

扫码关注我们
微信号：SRE实战
拒绝背锅 运筹帷幄