which type of query is the SQL result cache automatically disabled?

For which type of query is the SQL result cache automatically disabled?

For which type of query is the SQL result cache automatically disabled?

A.
Queries that access data which changes frequently

B.
Queries that return large amounts of data

C.
Queries that use SQL functions such as SYSDATE

D.
Queries that are used infrequently

Explanation:
SYSDATE produces a new value every time it is used. Caching such a value would make no sense.



Leave a Reply 1

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