Oracle Exam 1Z0-082 Topic 16 Question 98 Discussion

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

Question #: 98
Topic #: 16

[All 1Z0-082 Questions]

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: A, B

by Annabelle at Jul 18, 2024, 12:14 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-082 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Iluminada

12 days ago

I'm not sure, but I think it might be A. The value is changed only in the PFILE and takes effect at the next instance startup.

upvoted 0 times

...

Sherita

14 days ago

Hmm, this one seems tricky. I'll go with option D - the change is applied to the current instance, but doesn't persist after a restart. Gotta love those temporary database fixes, am I right?

upvoted 0 times

...

Hannah

14 days ago

I agree with Tu. Option B seems to be the correct one.

upvoted 0 times

...

Tu

17 days ago

I think the answer is B. The value is changed for the current instance and in the PFILE.

upvoted 0 times

...