Oracle
1Z0-050 · Question #72
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…
The correct answer is C. shared pool. See the full explanation below for the reasoning.
Question
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?
Options
- APGA
- Blarge pool
- Cshared pool
- Ddatabase buffer cache
How the community answered
(49 responses)- A16% (8)
- B4% (2)
- C73% (36)
- D6% (3)
Community Discussion
No community discussion yet for this question.