ocp-44

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

---

在您的数据库中，结果高速缓存模式参数已经在初始化
参数文件中设为手动。你发出以下命令：
SQL>SELECT /+ RESULT_CACHE / sale_category, sum(sale_amt)
FROM sales
GROUP BY sale_category;
此查询的结果将被储存在哪里？

B.共享池

---