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?
A.
The maximum size for the standard buffer cache is 100 MB.
B.
The minimum size for all buffer caches is 100 MB.
C.
The minimum size for the standard buffer cache is 100 MB.
D.
The maximum space in the buffer cache that can be released for dynamic distribution is
100 MB.
E.
The minimum space guaranteed in the buffer cache for any server process is 100 MB.
C
c
In this post:
http://www.oracleflash.com/8/Automatic-Shared-Memory-Management-in-Oracle-10g.html
SQL> alter system set db_cache_size=100m scope=both;
This means 100m is the minimum size for the buffer cache, no matter what happens to the other components this 100m will never be taken away from the Default buffer cache.
So, i think the correct answer is E.
Not A or D, because they talk about ‘maximum’.
Not B because ‘all buffer caches’.
Not C because ‘standard buffer cache’.
E