nerdexam
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)
  • A
    5% (1)
  • B
    9% (2)
  • C
    82% (18)
  • D
    5% (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.

Full 1Z0-515 Practice