Prev Question
Next 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?

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.

Explanation:
Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14237/initparams043.htm#REFRN10033

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *