Oracle
1Z0-515 · Question #33
For which type of query is the SQL result cache automatically disabled?
The correct answer is C. Queries that use SQL functions such as SYSDATE. SYSDATE produces a new value every time it is used. Caching such a value would make no
Advanced Concepts
Question
For which type of query is the SQL result cache automatically disabled?
Options
- AQueries that access data which changes frequently
- BQueries that return large amounts of data
- CQueries that use SQL functions such as SYSDATE
- DQueries that are used infrequently
How the community answered
(22 responses)- A5% (1)
- B9% (2)
- C82% (18)
- D5% (1)
Explanation
SYSDATE produces a new value every time it is used. Caching such a value would make no
Topics
#SQL result cache#SYSDATE#cache invalidation#non-deterministic functions
Community Discussion
No community discussion yet for this question.