Oracle
1Z0-067 · Question #219
1Z0-067 Question #219: Real Exam Question with Answer & Explanation
The correct answer is B. It succeeds only if memory is available from the autotuned components of the SGA.. See the full explanation below for the reasoning.
Question
Examine these parameter settings: SGA_TARGET = 700M SGA_MAX_SIZE = 1024M DB_8K_CACHE_SIZE = 124M LOG_BUFFER = 200M You attempt this: SQL> ALTER SYSTEM SER DB_8K_CACHE_SIZE=140M Which statement is true based on the information available?
Options
- AIt will fail because DB_8K_CACHE_SIZE cannot be changed dynamically.
- BIt succeeds only if memory is available from the autotuned components of the SGA.
- CIt will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within
- DIt will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within
Community Discussion
No community discussion yet for this question.