ocp 11g认证考试题:1Z0-051-078题,完整题库请点击这里联系老师咨询了解
78. Evaluate the following query:
SQL> SELECT TRUNC(ROUND(156.00,-1),-1)
FROM DUAL;
What would be the outcome?
A. 16
B. 100
C. 160
D. 200
E. 150
Answer: C
答案解析:
ROUND(156.00,-1)=160,四舍五入,精确到十位
TRUNC(160,-1)=160,截断精确到十位。