Oracle
1Z0-062 · Question #321
1Z0-062 Question #321: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-062 to reveal the answer and full explanation for question #321. The question stem and answer options stay visible for context.
Managing the Database Instance
Question
Your database instance is started with a PFILE. You want to increase the size of the buffer cache. Free memory is available to increase the size of the buffer cache. You execute the command: SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M; Which is the outcome?
Exhibit
Options
- AChange is applied to the current instance, but does not persist after instance restart.
- BThe value is changed only in the PFILE and takes effect at the next instance startup.
- CThe value is changed for the current instance and in the PFILE.
- DIt fails because the SCOPE clause is missing.
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
#PFILE#SPFILE#Dynamic Parameter Changes#Buffer Cache