代码改变世界

12c OCP考试专项 [1z0-071]-Q10: 数字函数(2020.06.17)

2020-06-17 22:24  askscuti  阅读(239)  评论(0编辑  收藏  举报

which is ture about the ROUND,TRUNC,and MOD functions?

A. ROUND(MOD(25,3),-1) and TRUNC(MOD(25,3),-1) are both valid give the same result.
B. ROUND(MOD(25,3),-1) is invalid.
C. ROUND(MOD(25,3),-1) and TRUNC(MOD(25,3),-1) are both valid,but give different results.
D. TRUNC(MOD(25,3),-1) is invalid.

Answer: A

Explanation:

MOD(25,3)取余数为1, ROUND(1,-1)和TRUNC(1,-1) 结果都为 0

提示:答案为个人理解和解答,难免有错,也欢迎大家及时指正。