Multiple choice technology databases

Which two types of query results cannot be stored in the query result cache? (Choose two.)

  1. subquery results

  2. results of a query having the SYSDATE function

  3. results of a query having the GROUP BY clause

  4. results of a query having the DATE data type in the WHERE clause
Reveal answer Fill a bubble to check yourself
A,B Correct answer
Explanation

Query result cache cannot store results from queries with non-deterministic functions like SYSDATE (which changes each execution). Subquery results are also excluded as they represent intermediate query constructs rather than final result sets.

Keep practicing — related questions