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.
database buffer cache

B.
shared pool

C.
PGA

D.
large pool



Leave a Reply 0

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