（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是保存在共享池库中的

ITPub博客

Oracle 11G OCP 1Z0-053 144