What will be displayed?

Evaluate the SQL statement:
SELECT ROUND(TRUNC(MOD(1600,10),-1),2)
FROM dual;
What will be displayed?

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.



Leave a Reply 0

Your email address will not be published. Required fields are marked *