The database instance was started up with the following initialization
parameter values:
MEMORY_TARGET = 500M
RESULT_CACHE_MODE = FORCE
RESULT_CACHE_MAX_SIZE = 0
After the database startup, to enable the result cache, you issued the following command:
SQL> ALTER SYSTEM SET result_cache_max_size = 2M SCOPE = MEMORY;
Which is the effect of this command?
A.
The query result cache is enabled and 2 MB of the memory target is allocated to the result cache.
B.
The query result cache is enabled and 0.25% of the memory target is allocated to the result cache.
C.
The command produces an error because the database instance is started up with the
RESULT_CACHE_MAX_SIZE parameter set to 0.
D.
The query result cache is not enabled because the database instance is started up with the
RESULT_CACHE_MAX_SIZE parameter set to 0.
Explanation:
If RESULT_CACHE_MAX_SIZE = 0, you have to restart the server
D