Oracle
1Z0-063 · Question #96
Automatic Shared Memory Management (ASMm) is enabled for your database instance, but parameters for the managed components are not defined. You execute this command: SQL> ALTER SYSTEM SET…
The correct answer is D. The maximum space in the buffer cache that can be released for dynamic distribution is 100 MB. See the full explanation below for the reasoning.
Question
Automatic Shared Memory Management (ASMm) is enabled for your database instance, but parameters for the managed components are not defined. You execute this command: SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M; Which statement is true?
Options
- AThe minimum size for the standard buffer cache is 100 MB.
- BThe maximum size for the standard buffer cache is 100 MB.
- CThe minimum space guaranteed in the buffer cache for any server process is 100 MB.
- DThe maximum space in the buffer cache that can be released for dynamic distribution is 100 MB.
- EThe minimum size for all buffer caches is 100 MB.
How the community answered
(38 responses)- A5% (2)
- B5% (2)
- C16% (6)
- D71% (27)
- E3% (1)
Community Discussion
No community discussion yet for this question.