What two types of results can be cached in the Result Set Cache?

Question

Options

• AResults of an SQL query
• BResults from a PL/SQL function
• CSequence object results
• DResult sets derived from data dictionary tables

• A
  81% (21)
• C
  8% (2)
• D
  12% (3)

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 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 The server-side caching can be of the following two types: * SQL Query Result Cache (A) * PL/SQL Function Result Cache (B)

No community discussion yet for this question.