Oracle
1Z0-052 · Question #69
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
Sign in or unlock 1Z0-052 to reveal the answer and full explanation for question #69. The question stem and answer options stay visible for context.
Managing the Database Instance
Question
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?
Options
- AThe command succeeds only if Automatic Memory Management is not enabled.
- BThe command succeeds, but you need to restart the database for changes to take effect.
- CThe command returns an error because the size of the redo log buffer cannot be changed dynamically.
- DThe parameter value is changed and it comes into effect as soon as space becomes available in the
Unlock 1Z0-052 to see the answer
You've previewed enough free 1Z0-052 questions. Unlock 1Z0-052 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#LOG_BUFFER#static parameters#SPFILE#ALTER SYSTEM