Multiple choice

Evaluate the following SQL statement:

SELECT ROUND (TRUNC (MOD (1600, 10),-1), 2) FROM dual;

What will be displayed?

  1. 0

  2. 1

  3. 0.00

  4. An error statement
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The correct answer is A because the expression evaluates step-by-step: MOD(1600,10) returns 0, TRUNC(0,-1) truncates to -1 decimal place giving 0, and ROUND(0,2) rounds to 2 decimal places still giving 0. Option B (1) is incorrect because the mod is 0, not 1600. Option C (0.00) is incorrect because ROUND(0,2) returns 0, not 0.00. Option D is incorrect because the syntax is valid.

Keep practicing — related questions