A deterministic query is run at 8am, takes 5 minutes, and the results are cached.
Which of the following statements are true? Choose 2 answers
A . The exact query win ALWAYS return me precomputed result set for the RESULT_CACHE_ACTIVE = time period
B . The same exact query will return the precomputed results if the underlying data hasn’t changed and the results were last accessed within the previous 24 hour period
C . The same exact query will return the precomputed results even if the underlying data has changed as long as the results were last accessed within the previous
D . The ”24 hour” on the percomputed results gets renewed every time the exact query is executed
Answer: B,D