题目内容

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. 抢劫、盗窃事件经过
B. 犯罪分子人员数量
C. 犯罪分子体貌特征
D. 犯罪分子所持武器
E. 传染疾病的扩展趋势

调速阀一般由差压减压阀与节流阀()而成。

A. 串联
B. 并联

焦炉加热制度中,“九温五压”指的是什么?

土体有哪些特点()。

A. 散体性
B. 多孔性
C. 多样性
D. 易变性
E. 坚硬性

答案查题题库