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 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.
Not sure. D…
A
If the parameter is specified, then the user-specified value indicates a minimum value for the memory pool.
Its A
A
A
A
A. Evident is here 🙂
https://docs.oracle.com/cd/B19306_01/server.102/b14237/initparams043.htm#REFRN10033
If SGA_TARGET is set: If the parameter is not specified, then the default is 0 (internally determined by the Oracle Database). If the parameter is specified, then the user-specified value indicates a minimum value for the memory pool.
A