QUESTION NO: 25
Evaluate the following SQL query;
What would be the outcome?
A. 200
B. 16
C. 160
D. 150
E. 100
Answer: C
答案解析：
参考：78：http://blog.csdn.net/rlhua/article/details/12853385
sys@TESTDB>select trunc(round(156.00,-1),-1) from dual;
TRUNC(ROUND(156.00,-1),-1)
--------------------------
160
Explanation:
Function Purpose
ROUND(column|expression, n) Rounds the column, expression, or value to n decimal places or, if
n is omitted, no decimal places (If n is negative, numbers to the left of decimal point are rounded.)
TRUNC(column|expression, n) Truncates the column, expression, or value to n decimal places or,
if n is omitted, n defaults to zero