ExamQuestions.com

Register
Login
Oracle Database 11g Advanced PLSQL Exam Questions

Oracle

Oracle Database 11g Advanced PLSQL

9 / 68

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