Multiple choice technology databases

What is the output of the following? SELECT ROUND(1111.93412,3) FROM DUAL;

  1. 1112

  2. 1111.93

  3. 1111.93412

  4. 1111.934

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

ROUND(1111.93412, 3) rounds to 3 decimal places. The digit in the 4th decimal place is 1, which is less than 5, so no rounding up occurs. The result is 1111.934.