Oracle Database Administration 2022 Certified Professional — Question 35

Which two actions can cause invalidation or loss of one or more results in the SQL Query Result Cache? (Choose two.)

Answer options

• A. One or more results were aged out of the result cache.
• B. result_cache_max_size is set dynamically to 0.
• C. A request was made by the RCBG background of a non-RAC database.
• D. A request was made by the RCBG background process in a physical standby database that is opened read only and whose primary has a result cache.
• E. Decreasing the value set for RESULT_CACHE_REMOTE_EXPIRATION.

Correct answer: A, B

Explanation

Option A is correct because results can age out of the cache when they are not accessed within a certain timeframe. Option B is also correct since setting result_cache_max_size to 0 effectively disables caching, leading to the loss of any stored results. The other options do not directly cause invalidation or loss of results in the SQL Query Result Cache.