Evaluate the SQL statement: SELECT ROUND (TRUNCATE (MOD (1600, 10), -1), 2)…
2025
Evaluate the SQL statement:
SELECT ROUND (TRUNCATE (MOD (1600, 10), -1), 2) FROM dual;
What will be displayed?
Answer: A. 0 — Explanation : The correct ans is 0. MOD(1600, 10) This function finds the remainder after division. 1600 / 10 = 160 with a remainder of 0. TRUNCATE(0, -1) The…
- A.
0
- B.
1
- C.
00
- D.
An error statement
Attempted by 695 students.
Show answer & explanation
Correct answer: A
Explanation : The correct ans is 0.MOD(1600, 10)
This function finds the remainder after division.
1600 / 10 = 160 with a remainder of 0.
TRUNCATE(0, -1)The second argument (-1) indicates truncating to the left of the decimal point (the tens place).
Since the input is already 0, any truncation at any level will result in 0.
ROUND(0, 2)This rounds the number to 2 decimal places.
Rounding 0 results in 0 (or 0.00 depending on the display format).
Final Output:
0