54.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.
Answer: A
有关上述功能，哪种说法是真实的？
当任何对 EMPLOYEES 表结构上的变化完成时，缓存结果就变成无效了。
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.
Answer: A
有关上述功能，哪种说法是真实的？
当任何对 EMPLOYEES 表结构上的变化完成时，缓存结果就变成无效了。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/81227/viewspace-2123052/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
1Z0-053 V13.02 Q48
下一篇：
1Z0-053 V13.02 Q55
请登录后发表评论
登录
全部评论
