Prev Question
Next Question

Automatic Shared Memory Management (ASMM) is enabled for your database instance. You execute the
following command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;
Which statement is true?

A.
It succeeds and the minimum size for the DEFAULT buffer pool is set to 100M.

B.
It fails because DB_CACHE_SIZE is a static initialization parameter.

C.
It fails because ASMM is enabled and individual SGA components cannot be sized.

D.
It succeeds and the value is changed in the SPFILE immediately, but the change takes effect only at the
next instance startup.

Prev Question
Next Question

Leave a Reply

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