The database instance was started up using the automatic memory management feature. No
value was set for the RESULT_CACHE_MAX_SIZE parameter.
Examine the following initialization parameter settings for your database:
MEMORY_TARGET = 500M
RESULT_CACHE_MODE = MANUAL
You execute a query by using the result_cache hint. Which statement is true in this scenario?
A.
The query results are not stored because no memory is allocated for the result cache.
B.
The query results are stored and 0.5% of the memory target is allocated to the result cache.
C.
The query results are stored and 0.25% of the memory target is allocated to the result cache.
D.
The query results are not stored because the RESULT_CACHE_MODE parameter is not set to FORCE.
C
http://dbaora.com/sql-result-cache-11g/
? Not see any explaination on that link?