Which statement is true regarding the above function?

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?

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.



Leave a Reply 0

Your email address will not be published. Required fields are marked *