ExamQuestions.com

Register
Login
Oracle Database 11g Advanced PLSQL Exam Questions

Oracle

Oracle Database 11g Advanced PLSQL

40 / 68

Question 40:

The database instance was recently started up. Examine the following parameter settings for the database instance: 
image
You reset the value for the result_cache_max_size parameter by issuing the following command: 
image
Which statement is true in this scenario? 

Answer options:

A. 1056 KB is allocated for the result cache and the result cache is enabled
B. 1056 KB is allocated for the result cache but the result cache is disabled
C. The results is only for the queries that have the RESULT_CACHE hint are cached
D. The results for all the queries except those having the NO_RESULT_CACHE hint are cached