Multiple choice technology databases

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

  1. 0

  2. 100

  3. 123

  4. -123
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

ROUND(-123.39953, -3) rounds to the nearest thousand. Since the number is negative and between -1000 and 0, it rounds to 0. The third parameter -3 means round to 3 decimal places to the left of the decimal point (thousands place).

AI explanation

To answer this question, we need to understand the ROUND function in SQL.

The ROUND function is used to round a number to a specified number of decimal places or to the nearest whole number. It takes two arguments: the number to be rounded and the number of decimal places to round to.

In this case, the number to be rounded is -123.39953 and the number of decimal places to round to is -3.

When rounding to -3 decimal places, we are rounding to the nearest thousands place.

The correct answer is A) 0.

This is because -123.39953, when rounded to the nearest thousands place, becomes 0.

Keep practicing — related questions