Prev Question
Next Question

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=32 M;
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.
It returns an error because the value of this parameter cannot be changed dynamically.

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

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

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *