nerdexam
Oracle

1Z0-062 · Question #247

1Z0-062 Question #247: Real Exam Question with Answer & Explanation

Sign in or unlock 1Z0-062 to reveal the answer and full explanation for question #247. The question stem and answer options stay visible for context.

Managing the Database Instance

Question

Your database instance is started by using a server parameter file (SPFILE). You execute the following command to change thevalue of the LOG_BUFFER initialization parameter: ALTER SYSTEM SET LOG_BUFFER=32 M; What is the outcome of this command?

Options

  • AThe parameter value is changed and it comes into effect as soon as space becomes available in
  • BIt returns an error because the value of this parameter cannot be changed dynamically.
  • CThe parameter value is changed and it comes into effect at the next instance startup.
  • DIt returns an error because SCOPE should be set to MEMORY.

Unlock 1Z0-062 to see the answer

You've previewed enough free 1Z0-062 questions. Unlock 1Z0-062 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

#initialization parameters#SPFILE#dynamic parameters#LOG_BUFFER
Full 1Z0-062 Practice