Oracle
1Z0-082 · Question #82
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…
The correct answer is D. Change is applied to the current instance, but does not persist after instance restart. https://docs.oracle.com/database/121/SQLRF/statements_2017.htm#SQLRF00902
Manage the Database Instance
Question
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?
Exhibit
Options
- 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
How the community answered
(25 responses)- A4% (1)
- B4% (1)
- C12% (3)
- D80% (20)
Explanation
https://docs.oracle.com/database/121/SQLRF/statements_2017.htm#SQLRF00902
Topics
#PFILE#ALTER SYSTEM#parameter scope#buffer cache
Community Discussion
No community discussion yet for this question.