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博客

oracle.1z0-053: RESULT_CACHE_MODE

最新文章