Identify the result of the analysis that would indicate the most potential for improvement with result set caching.

You think that result set caching might provide some benefits for your current data warehouse
scenario. You perform some analysis on the composition of the queries used in the scenario.
Identify the result of the analysis that would indicate the most potential for improvement with result
set caching.

A.
The scenario consists mainly of queries that are used infrequently.

B.
The scenario consists mainly of queries that work on data which changes frequently.

C.
The scenario consists mainly of queries with long run times and small result sets.

D.
All data warehouse scenarios will benefit from result set caching.

Explanation:
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.
Reference: query result cache in oracle 11g, http://www.oracle-developer.net/display.php?id=503