---

Evaluate the following function code：   CREATE FUNCTION get_dept_avg（dept_id NUMBER） RETURN NUMBER RESULT_CACHE RELIES_ON （EMPLOYEES） IS avgsal NUMBER（6）； BEGIN  SELECT AVG（SALARY）INTO avgsal FROM EMPLOYEES   WHERE DEPARTMENT_ID = dept_id； RETURN avgsal； END get_dept_avg；   Which statement is true regarding the above function？（）
A: The cached result becomes invalid when any structural change is done to the EMPLOYEES table. 
B: If the function execution results in an unhandled exception，the exception result is also stored in the cache.
C: Each time the function is invoked in a different session，the current result in the result cache gets overwritten.
D: If the function is invoked with a different parameter value，the existing result in the result cache gets overwritten by the latest value.

---

出自：Oracle认证

显示答案