Practice exercise

• 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.

• 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 SQL uses the RESULT_CACHE hint.

  2. The query results are...