移动端

  • 题王微信公众号

    题王微信公众号

    微信搜“题王网”真题密题、最新资讯、考试攻略、轻松拿下考试

单选题

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?()

发布日期:2021-09-17

Evaluate the following function code:   CREATE FUN...
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.

标签: "暂无标签"

题王网让考试变得更简单

扫码关注题王,更多免费功能准备上线!