問題文
A query whose result is held in the server result cache is issued again after a transaction has updated one of the tables it reads. What happens to the held result?
選択肢
- It is invalidated because the least recently used entry is discarded whenever a new entry needs room in the area for itself.
- It is invalidated because a change to the data or the metadata of an object that built it makes the copy stale.
- It is kept because the cache stores the text of the statement and the text has not changed since the result was stored.
- It is kept because the cache holds results for a fixed period and the period for this result has not yet elapsed.