Oracle Exam 1Z0-062 Topic 9 Question 43 Discussion

Actual exam question for Oracle's 1Z0-062 exam

Question #: 43
Topic #: 9

Examine the parameters:

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?

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.

Show Suggested Answer

Suggested Answer: A

by Linn at May 07, 2022, 11:33 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!