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 function rounds to specified decimal places. ROUND(1111.93412, 3) keeps 3 decimal places, so 1111.93412 becomes 1111.934 - the fourth decimal (1) is dropped, not rounded up because it's less than 5.