Practice exercise

1. The initialization parameter settings for your database are as follows:

   MEMORY_TARGET = 500M
   RESULT_CACHE_MODE = MANUAL
   RESULT_CACHE_MAX_SIZE = 0

   You execute a query by using the RESULT_CACHE hint. Which statement is true in this scenario?

   1. The query results are not stored in the cache because no memory is allocated for the result cache.

   2. The query results are stored in the cache because Oracle implicitly manages the cache memory.

   3. The query results are not stored in the cache because RESULT_CACHE_MODE is MANUAL.

   4. The query results are stored in the cache automatically when RESULT_CACHE_MODE is MANUAL.

2. You set the following initialization parameter settings for your database:

   MEMORY_TARGET = 500M
   RESULT_CACHE_MODE = FORCE
   RESULT_CACHE_MAX_SIZE = 200M

   You execute the following query:

   SELECT /*+RESULT_CACHE*/ ENAME, DEPTNO
   FROM EMPLOYEES
   WHERE EMPNO = 7844
   /

   Which of the following statements are true?

   1. The query results are cached because the SQL uses the RESULT_CACHE hint.

   2. The query results...