Examine the query: The RESULT_CACHE_MODE parameter is set to MANUAL for the database. Which two statements are true about the usage of the result cache?

Question

Options

• AThe SQL runtime environment checks whether the query result is cached in the result cache; if the
• BThe SQL runtime environment does check for the query result in the result cache because the
• CThe SQL runtime environment checks for the query result in the result cache only when the query is
• DIf the query result does not exist in the cache and the query is executed, the result is generated as

• A
  76% (19)
• B
  16% (4)
• C
  8% (2)

Explanation

• result_cache_mode: the result cache can be enabled in three ways: via hint, alter session or alter system. Default is MANUAL which means that we need to explicitly request caching via the RESULT_CACHE hint; * As its name suggests, the query result cache is used to store the results of SQL queries for re- use in subsequent executions. By caching the results of queries, Oracle can avoid having to repeat the potentially time-consuming and intensive operations that generated the resultset in the first place (for example, sorting/aggregation, physical I/O, joins etc). The cache results themselves are available across the instance (i.e. for use by sessions other than the one that first executed the query) and are maintained by Oracle in a dedicated area of memory. Unlike our homegrown solutions using associative arrays or global temporary tables, the query result cache is completely transparent to our applications. It is also maintained for consistency automatically, unlike our own caching programs. * RESULT_CACHE_MODE specifies when a ResultCache operator is spliced into a query's The ResultCache operator is added only when the query is annotated (that is, hints). The ResultCache operator is added to the root of all SELECT statements (provided that it is valid For the FORCE setting, if the statement contains a NO_RESULT_CACHE hint, then the hint takes precedence over the parameter setting.

No community discussion yet for this question.