Upgrade Oracle DBA 11g to Oracle Database 12c — Question 24

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 DB_CACHE_SIZE to 100M indicates the maximum space that can be allocated for dynamic distribution within the buffer cache. Options A, B, and C are incorrect as they misinterpret the implications of the DB_CACHE_SIZE setting, and option E incorrectly states the minimum size for all buffer caches.