问题:
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.
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?()
● 参考解析
本题暂无解析