Oracle Exam 1Z0-082 Topic 13 Question 40 Discussion

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

Question #: 40
Topic #: 13

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?

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

Show Suggested Answer

Suggested Answer: D

by Wilda at May 03, 2022, 11:43 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

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