Chapter 9, Caching to Improve Performance

Question No.	Answer	Explanation
1	a	The database server would cache the query results only when the user explicitly allocates the cache memory at the server and the caching feature is enabled. In the given scenario, caching is disabled as the value of the RESULT_CACHE_MAX_SIZE parameter is 0.
2	b and d	In automatic result caching, the RESULT_CACHE hint is ineffective as the server implicitly caches results of all SQL queries.
3	a	When the dependent table data gets updated, all the cached results get invalidated.
4	b	The cached results are stored at the server and are sharable across the sessions of the user.
5	b	PL/SQL result cache feature is operative only upon the functions which are declared as standalone or local to a stored subprogram or within a package.
6	a	The RELIES_ON clause has been deprecated in Oracle 11g R2.
7	b and c	The server doesn't cache the results of the queries which use sequence or any pseudo column (here SYSDATE).
8	b	PL/SQL function result cache works on server-side memory infrastructure which is the same for both SQL and PL/SQL. Only the results of functions can be cached at the server. The function must not be a pipelined one or the one declared with invoker's rights. It should accept parameters in the pass by reference mode of primitive data types only.
9	a and b	The valid values are PUBLISHED, NEW, INVALID, BYPASS, and EXPIRED.
10	a, b, c, and d	The V$RESULT_CACHE_STATISTICS dynamic performance view stores the latest cache memory statistics.