Oracle Exam 1Z0-148 Topic 9 Question 15 Discussion

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

Question #: 15
Topic #: 9

In which two situations will a result-cached function execute even though no change was made on a dependent table or view? (Choose two.)

Awhen a function was created with invoker's rights using AUTHID CURRENT_USER

Bwhen the database administrator has disabled the use of the result cache

Cwhen the results for the function have aged out of the cache

Dwhen the RELIES_ON clause was not used while creating the function

Ewhen a new session was opened to invoke the function which is already cached

Show Suggested Answer

Suggested Answer: B, C

by Portia at May 08, 2022, 05:40 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!