1Z0-082 practice question 21 of 25

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?

Full set: 142 questions
Answer options
A: in the SPFILE, SPFILE, and memory
B: in the SPFILE and in memory Correct answer
C: only In the SPFILE
D: in the SPFILE and SPFILEc
E: only in memory
Correct Answer:
B. in the SPFILE and in memory
Explanation

When an Oracle instance is started using a Server Parameter File (SPFILE), the ALTER SYSTEM SET command, by default, uses SCOPE=BOTH. This means the change is applied immediately to the running instance (memory) and is also persisted in the SPFILE. This ensures the change will be active after the next instance restart. The existence of a PFILE is irrelevant as the instance is not using it.

Why Incorrect

A. This option redundantly lists SPFILE twice and is incorrectly formatted.
C. This would be correct only if SCOPE=SPFILE were specified, which is not the default behavior.
D. There is no such component as an "SPFILEc" in the Oracle Database architecture.
E. This would be correct only if SCOPE=MEMORY were specified, which is not the default behavior.

References

Oracle Database Administrator's Guide

19c

Chapter 2

"Managing Initialization Parameters Using a Server Parameter File". The section "Changing Initialization Parameter Values" states

"If you specify SCOPE=BOTH

then Oracle Database changes the value in memory and in the server parameter file. This is the default."

Oracle Database SQL Language Reference

19c

"ALTER SYSTEM". Under the setclause

the documentation for SCOPE specifies: "BOTH: ... This is the default if the database is started up with a server parameter file."

Scroll to Top