Oracle
1Z0-082 · Question #141
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?
The correct answer is D. in the SPFILE and SPFILEc. See the full explanation below for the reasoning.
Manage the Database Instance
Question
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?
Options
- Ain the SPFILE, SPFILE, and memory
- Bin the SPFILE and in memory
- Conly In the SPFILE
- Din the SPFILE and SPFILEc
- Eonly in memory
How the community answered
(32 responses)- A3% (1)
- B6% (2)
- D75% (24)
- E16% (5)
Topics
#SPFILE#ALTER SYSTEM#database parameters#memory
Community Discussion
No community discussion yet for this question.