Where would the result of this query be stored?

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?

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.
Shared pool

B.
Database buffer cache

C.
Large pool

D.
PGA



Leave a Reply 0

Your email address will not be published. Required fields are marked *