Intermediate
Database Management Systems
Q78 / 100
What is query result caching and what risk does it introduce?
Correct! Well done.
Incorrect.
The correct answer is C) Storing the output of a query so repeated identical requests skip re-execution, with the risk of returning stale results if underlying data changes before the cache is invalidated
C
Correct Answer
Storing the output of a query so repeated identical requests skip re-execution, with the risk of returning stale results if underlying data changes before the cache is invalidated
Explanation
Caching layers (application-level caches, query caches) avoid redundant computation for repeated reads, greatly reducing load. The trade-off is staleness: if the cache isn't invalidated when data changes, clients may see outdated results.
Progress
78/100