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

Get Advanced Oracle PL/SQL Developer's Guide - Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.