555. Evaluate the following function code:CREATE FUNCTION get_de

555. Evaluate the following function code:CREATE FUNCTION get_dept_avg(dept_id NUMBER)RETURN NUMBERRESULT_CACHE RELIES_ON (EMPLOYEES)ISavgsal NUMBER(6);BEGINSELECT AVG(SALARY)INTO avgsalFROM EMPLOYEESWHERE DEPARTMENT_ID = dept_id;RETURN avgsal;END get_dept_avg;\nWhich 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 getsoverwritten.

D.If the function is invoked with a different parameter value, the existing result in the result cache getsoverwritten by the latest value.

正确答案是A