Question 9
Examine this function header:
FUNCTION calc_new_sal (emp_id NUMBER) RETURN NUMBER;
You want to ensure that whenever this PL/SQL function is invoked with the same parameter value across active sessions, the result is not recomputed.
If a DML statement is modifying a table which this function depends upon, the function result must be recomputed at that point in time for all sessions calling this function.
Which two actions should you perform?
Ensure RESULT_CACHE_MAX_SIZE is greater than 0.
Enable the result cache by using DBMS_RESULT_CACHE.BYPASS (FALSE).
Add the deterministic clause to the function definition.
Add the RELIES_ON clause to the function definition.
Add the RESULT_CACHE clause to the function definition.
Correct answer: AC