1Z0-515 · Question #69
Which condition can cause a change in the contents of the SQL Result Set Cache?
The correct answer is B. SQL result sets are invalidated in the Result Set Cache after DML is performed against any of. The database automatically invalidates a cached result whenever a transaction modifies the data or metadata of any of the database objects used to construct that cached result. Note: DML is abbreviation of Data Manipulation Language. It is used to retrieve, store, modify…
Question
Which condition can cause a change in the contents of the SQL Result Set Cache?
Options
- ASQL result sets age out of the Result Set Cache based on the KEEP parameter.
- BSQL result sets are invalidated in the Result Set Cache after DML is performed against any of
- CSQL result sets are pinned in the Result Set Cache with the KEEP parameter.
- DNone of these would cause a change.
How the community answered
(32 responses)- A3% (1)
- B84% (27)
- C9% (3)
- D3% (1)
Explanation
The database automatically invalidates a cached result whenever a transaction modifies the data or metadata of any of the database objects used to construct that cached result. Note: DML is abbreviation of Data Manipulation Language. It is used to retrieve, store, modify, delete, insert and update data in database.
Topics
Community Discussion
No community discussion yet for this question.