1Z0-515 · Question #67
You want to enable result set caching to quickly see if this feature will help the performance of your application. Which is the quickest way to make this determination?
The correct answer is A. Set RESULT_CACHE_MODE = FORCE in the initialization file. The RESULT_CACHE_MODE initialization parameter determines the SQL query result cache mode. The parameter specifies when a ResultCache operator is spliced into a query's execution plan. The parameter accepts the following values: The ResultCache operator is added to the root of…
Question
You want to enable result set caching to quickly see if this feature will help the performance of your application. Which is the quickest way to make this determination?
Options
- ASet RESULT_CACHE_MODE = FORCE in the initialization file.
- BSet RESULT_CACHE = ENABLED in the initialization file.
- CSet RESULT_CACHE_MAX_SIZE = 0.
- DSet RESULT_CACHE = ENABLED in the initialization file and use a RESULT_CACHE hint in
How the community answered
(23 responses)- A78% (18)
- B13% (3)
- C4% (1)
- D4% (1)
Explanation
The RESULT_CACHE_MODE initialization parameter determines the SQL query result cache mode. The parameter specifies when a ResultCache operator is spliced into a query's execution plan. The parameter accepts the following values: The ResultCache operator is added to the root of all SELECT statements, if that is possible. However, if the statement contains a NO_RESULT_CACHE hint, then the hint takes precedence over the parameter setting. The ResultCache operator is added, only if you use the RESULT_CACHE hint in the SQL query.
Topics
Community Discussion
No community discussion yet for this question.