Oracle Exam 1Z0-082 Topic 15 Question 104 Discussion

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

Question #: 104
Topic #: 15

[All 1Z0-082 Questions]

Your database instance is started with an SPFILE.

A PFILE is also available. You execute this command:

ALTER SYSTEM SET DB_CACHE_SIZE=100K;

Where Is the value changed?

Ain the SPFILE, SPFILE, and memory

Bin the SPFILE and in memory

Conly In the SPFILE

Din the SPFILE and SPFILEc

Eonly in memory

Show Suggested Answer

Suggested Answer: D

by Yesenia at Sep 16, 2024, 09:43 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Tomoko

7 months ago

I'm just going to close my eyes and pick an answer. This database stuff is like magic to me!

upvoted 0 times

Deandrea

6 months ago

User 3: I'm not sure, but I think it's changed in the SPFILE, SPFILE, and memory.

upvoted 0 times

...

Chun

6 months ago

No, it's actually changed only in the SPFILE.

upvoted 0 times

...

Aileen

6 months ago

I think the value is changed in the SPFILE and in memory.

upvoted 0 times

...

Dewitt

7 months ago

I'm not sure about that. I think the value is only changed in the SPFILE.

upvoted 0 times

...

Rebbecca

7 months ago

I agree with Audra. The DB_CACHE_SIZE value should be updated in both the SPFILE and in memory.

upvoted 0 times

...

Phil

7 months ago

This is a trick question! The value is changed in both the SPFILE and the PFILE, right? I'll choose D just to be safe.

upvoted 0 times

...

Alecia

7 months ago

Wait, isn't the SPFILE supposed to be the only place where the value is stored? I'm picking option C.

upvoted 0 times

Rory

6 months ago

User4: Option C it is then, let's stick with that.

upvoted 0 times

...

Norah

6 months ago

User2: I agree, I'll go with option C as well.

upvoted 0 times

...

Christa

6 months ago

User3: Yeah, the SPFILE is where the value should be updated.

upvoted 0 times

...

Valene

6 months ago

I think the value is only changed in the SPFILE.

upvoted 0 times

...

Trina

8 months ago

Hmm, I think the value is only changed in the SPFILE, so I'll go with option C.

upvoted 0 times

Rodolfo

7 months ago

Option C it is then.

upvoted 0 times

...

Jose

7 months ago

I'm not sure, but I'll go with option C too.

upvoted 0 times

...

Oretha

7 months ago

Yeah, I agree. Option C seems correct.

upvoted 0 times

...

Floyd

7 months ago

I think the value is only changed in the SPFILE.

upvoted 0 times

...

Audra

8 months ago

I think the value is changed in the SPFILE and in memory.

upvoted 0 times

...

Brunilda

8 months ago

The value is changed in the SPFILE and in memory, so I'm going with option B.

upvoted 0 times

Gaynell

7 months ago

Yeah, I agree. Option B seems to be the correct choice.

upvoted 0 times

...

Alise

7 months ago

I think the value is changed in the SPFILE and in memory.

upvoted 0 times

...