1Z0-148 Web TestEngine demo

Exit VCEDump 1Z0-148 Oracle Database: Advanced PL/SQL
Question 34 of 37
0% complete
Q34 Single choice

Examine these statements:

1. A function with invoker's rights can be result cached by using both AUTHID CURRENT_USER and RESULT_CACHE in its declaration.
2. A function with invoker's rights cannot be result cached because it may allow a user to retrieve data cached by another user.
3. Results in the result cache for an invoker's rights function will be cached by the value of CURRENT_SCHEMA in the invoking environment.
4. By default, declaring a function with RESULT_CACHE makes it an invoker's rights result cached function.
5. A function with invoker's rights can be result cached because the function result cache is created per user for invoker's rights functions.

Identify the set of correct statements with respect to invoker's rights and function result caching.

Sign in to mark questions

Sign in to save marked questions and return to this demo.

Sign in