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 fourth decimal is 1, which is less than 5, so we round down. Result: 1111.934. Option A shows integer rounding, B shows 2 decimals, C shows no change (original number).