Oracle Database 12c: Advanced Administration — Question 82

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?

Answer options

• A. The minimum size for the standard buffer cache is 100 MB.
• B. The maximum size for the standard buffer cache is 100 MB.
• C. The minimum space guaranteed in the buffer cache for any server process is 100 MB.
• D. The maximum space in the buffer cache that can be released for dynamic distribution is 100 MB.
• E. The minimum size for all buffer caches is 100 MB.

Correct answer: D

Explanation

The correct answer is D because setting the DB_CACHE_SIZE to 100M specifies the maximum space that can be dynamically distributed for the buffer cache. The other options incorrectly interpret the implications of this setting regarding minimum and maximum sizes or guarantees for buffer cache space.