Oracle Exam 1Z0-084 Topic 1 Question 31 Discussion

Actual exam question for Oracle's 1Z0-084 exam

Question #: 31
Topic #: 1

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

AOne or more results were aged out of the result cache.

Bresult_cache_max_size is set dynamically to 0.

CA request was made by the RCBG background of a non-RAC database.

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

EDecreasing the value set for RESULT_CACHE_REMOTE_EXPIRATION.

Show Suggested Answer

Suggested Answer: A, B

The SQL Query Result Cache stores the results of queries and PL/SQL function calls for reuse. However, entries in the result cache can be invalidated or lost under certain conditions:

A) Results can be aged out of the cache when the cache becomes full and new results need to be stored. This process ensures that the cache does not exceed its allocated memory and that it contains the most recently used entries.

B) Setting the RESULT_CACHE_MAX_SIZE parameter to 0 will effectively disable the result cache and all cached results will be lost, as Oracle will no longer allocate any memory to the result cache.

Oracle Database Performance Tuning Guide, 19c

by Shanice at Mar 21, 2025, 04:18 AM

Limited Time Offer

25%

1 months ago

B and D seem like the most likely answers to me. Anything that affects the cache size or availability would cause invalidation or loss of results.

upvoted 0 times

Carman

1 days ago

Yes, those actions could definitely lead to invalidation or loss of results in the SQL Query Result Cache.

upvoted 0 times

...

Paulina

22 days ago

I agree, B and D both involve changes to the cache size or availability.

upvoted 0 times

...

Annamae

1 months ago

I think option A and D can cause invalidation of results.

upvoted 0 times

...