Evaluate the SQL statement:
SELECT ROUND(TRUNC(MOD(1600,10),-1),2)
FROM dual;
What will be displayed?
A.
0.00
B.
0
C.
1
D.
an error statement
Explanation:
Result will be 0. MOD(x,y) function calculates the modulus of x, defined in long division as the
integer remainder when x is divided by y until no further whole number can be produced. TRUNC()
function truncates x to the decimal precision of y. ROUND(x,y) rounds x to the decimal precision of y.