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

The correct answer is A. 0. 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…

Using Functions (Single-Row, Group, Conversion, Conditional)

Question

Evaluate the SQL statement:

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

Options

A0
B1
C0.00
DAn error statement

How the community answered

(56 responses)

A
79% (44)
B
11% (6)
C
7% (4)
D
4% (2)

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 Incorrect Answers B: Result will be 0, not 1. C: Result will be 0, not 0.00 because MOD(1600,10) return 0 and all other functions (TRUNC and ROUND) return 0 also. D: There is no error in this statement.

Topics

#MOD function#TRUNC function#ROUND function#nested functions

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice