Oracle 11G OCP 1Z0-053 144

(144)In your database,the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file.

You issued the following command:

SQL>SELECT/*+RESULT_CACHE*/ sale_category,sum(sale_amt) FROM sales GROUP BY sale_category;

Where would the result of this query be stored?

A. database buffer cache

B. shared pool

C. PGA

D. large pool

答案:(B)

解析:

Result cache是保存在共享池库中的

请使用浏览器的分享功能分享到微信等