多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

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.
正确答案:A
答案解析:
进入题库查看解析

微信扫一扫手机做题