Which statement is true in this scenario?

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?

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.



Leave a Reply 2

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