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 7 sale_categoiy, sum(sale_amt)
FROM sales
GROUP BY sale_categoiy;
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 7 sale_categoiy, sum(sale_amt)
FROM sales
GROUP BY sale_categoiy;
Where would the result of this query be stored?

A.
PGA

B.
large pool

C.
shared pool

D.
database buffer cache



Leave a Reply 0

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