Oracle Database Administration I — Question 123

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?

Answer options

• A. in the SPFILE, PFILE, and memory
• B. in the SPFILE and in memory
• C. only in the SPFILE
• D. only in memory
• E. in the SPFILE and PFILE

Correct answer: B

Explanation

The command alters the DB_CACHE_SIZE in the memory and persists the change in the SPFILE, which allows for the value to be retained across instance restarts. The PFILE remains unchanged, as the ALTER SYSTEM command does not affect it directly, making option B the correct choice.