OCP 1Z0 051 QUESTION NO: 25

Evaluate the following SQL query;

SQL> SELECT TRUNC(ROUND(156.00,-1),-1) FROM DUAL;
What would be the outcome?
 
 
A. 200 
B. 16 
C. 160 
D. 150 
E. 100 
 
Answer: C

考核的四舍五入与截断
这个语句在应用trunc之前，数据已四舍五入到了10位。trunc将不能再截断数字。所以结果是160

SQL> SELECT ROUND(156.00,-1) FROM DUAL;ROUND(156.00,-1)----------------             1601 row selectedExecuted in 0 secondsSQL> SELECT TRUNC(156.00,-1) FROM DUAL;TRUNC(156.00,-1)----------------             1501 row selectedExecuted in 0.016 secondsSQL> SELECT TRUNC(ROUND(156.00,-1),-1) FROM DUAL;TRUNC(ROUND(156.00,-1),-1)--------------------------                       1601 row selected