Question 9:
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?
Answer options:
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