Which condition can cause a change in the contents of the SQL Result Set Cache?
A.
SQL result sets age out of the Result Set Cache based on the KEEP parameter.
B.
SQL result sets are invalidated in the Result Set Cache after DML is performed against any of
tables in the SQL query.
C.
SQL result sets are pinned in the Result Set Cache with the KEEP parameter.
D.
None of these would cause a change.
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.
Reference: From oracle documentation
http://docs.oracle.com/cd/B28359_01/server.111/b28318/memory.htm#BGBEEFBE