oracle.1z0-053: RESULT_CACHE_MODE

QUESTION NO: 44
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
Answer: B
Explanation:

The server result cache is a memory pool within the shared pool. This pool contains a SQL query result cache, which stores results of SQL queries, and a PL/SQL function result cache, which stores values returned by PL/SQL functions.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29555029/viewspace-1612590/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29555029/viewspace-1612590/