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

The ROUND function in SQL rounds a number to the specified decimal places. ROUND(1111.93412, 3) rounds to 3 decimal places, giving 1111.934. Option A (1112) would require 0 decimal places, option B (1111.93) would be 2 decimal places, and option C shows the original number unchanged.