What two types of results can be cached in the Result Set Cache?
A.
Results of an SQL query
B.
Results from a PL/SQL function
C.
Sequence object results
D.
Result sets derived from data dictionary tables
Explanation:
Your applications sometime send repetitive queries to the database. To improve the
response time of repetitive queries, results of queries, query fragments, and PL/SQL functions can
be cached in memory. A result cache stores the results of queries shared across all sessions.
When these queries are executed repeatedly, the results are retrieved directly from the cache
memory.
You must annotate a query or query fragment with a result cache hint to indicate that results are to
be stored in the query result cache.
The query result set can be cached in the following ways:
* Server-side Cache
* Client Result Cache
Oracle Database 11g Release 1 (11.1) provides support for server-side Result Set caching for
both JDBC types. The server-side result cache is used to cache the results of the current queries,
query fragments, and PL/SQL functions in memory and then to use the cached results in future
executions of the query, query fragment, or PL/SQL function. The cached results reside in the
result cache memory portion of the SGA. A cached result is automatically invalidated whenever a
database object used in its creation is successfully modified. The server-side caching can be of
the following two types:
* SQL Query Result Cache (A)
* PL/SQL Function Result Cache (B)