A Deterministic Query Is Run at 8am, Takes 5 Minutes

question 17

Multiple Choice

A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of the following statements are true? (Choose two.)

• A) The exact query will ALWAYS return the 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 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 24 hour period
• D) The "24 hour" timer on the precomputed results gets renewed every time the exact query is executed

---

Definitions:

Time Value

The concept that money available at the present time is worth more than the identical sum in the future due to its potential earning capacity.

Soft Capital Rationing

Internal limitations set by a company's management on the amount of funding allocated for new projects.

Debt Covenants

Agreements between a borrower and lender that stipulate certain conditions the borrower must adhere to, which can pertain to financial ratios, levels of income, or other financial benchmarks.

Time Value

The idea that having money now is more valuable than having the same sum at a later date because of its ability to earn more over time.