Multiple choice technology databases

SELECT ROUND (-123.39953,-2) FROM DUAL;

  1. -123.40

  2. -100

  3. -120

  4. -123.30

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

The SQL ROUND function with a negative second argument rounds the value to the left of the decimal point. Specifically, -2 rounds to the nearest hundred. Since -123.39953 is closer to -100 than -200, it rounds to -100.