Exam 1z0-148 topic 1 question 67 discussion

Actual exam question from Oracle's 1z0-148

Question #: 67
Topic #: 1

[All 1z0-148 Questions]

In which situation will cached results become invalid?

A. When the memory allocated to the server result cache is increased using the RESULT_CACHE_MAX_SIZE initialization parameter
B. When a session executes an insert, update, or delete statement on a table or view that is queried by the result-cached function
C. When a session on this database instance invokes the function with the same parameter values
D. When the RESULT_CACHE_MODE parameter is set to FORCE.
E. When a new session is opened to invoke the function which is already cached

Show Suggested Answer

Suggested Answer: CD 🗳️
Reference:
https://docs.oracle.com/database/121/TGDBA/tune_result_cache.htm

by orakell at Dec. 1, 2019, 10:26 p.m.

Comments

Submit Cancel

orakell

Highly Voted 5 years, 6 months ago

The only correct answer here is B according to that link. "Cached query results become invalid when data in the database object(s) being accessed by the query is (are) modified."

upvoted 8 times