Oracle
1Z0-082 · Question #82
1Z0-082 Question #82: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-082 to reveal the answer and full explanation for question #82. The question stem and answer options stay visible for context.
Question
Your database instance is started with a PFILE. Examine these parameters: 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; What is the outcome?
Exhibit
Options
- AThe value is changed only in the PFILE and takes effect at the next instance startup
- BThe value is changed for the current instance and in the PFILE
- CIt fails because the SCOPE clause is missing
- DChange is applied to the current instance, but does not persist after instance restart
Unlock 1Z0-082 to see the answer
You've previewed enough free 1Z0-082 questions. Unlock 1Z0-082 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.