Question

State the output of the following query: \[ \text{SELECT ROUND(9873.567,-2);} \]

• A. 9900
• B. 9873
• C. 9800
• D. 9873.5

Hint:

Negative values in ROUND() move rounding to the left of the decimal: -1 = nearest 10, -2 = nearest 100, -3 = nearest 1000.

Answer 1

The Correct Option is C

Step 1: Understanding ROUND().
The \texttt{ROUND(number, n)} function rounds a specified number to a designated place value determined by \texttt{n}. - A positive \texttt{n} indicates rounding to decimal places.
- An \texttt{n} of 0 results in rounding to the nearest integer.
- A negative \texttt{n} signifies rounding to the left of the decimal point.

Step 2: Application Example.
- Number: 9873.567
- Parameter (\texttt{n}): -2, instructing to round to the nearest hundred.
- For 9873.567, the tens digit is 7. Since 7 is greater than or equal to 5, we round the hundreds digit up.
\[9873.567 \approx 9800\]
Step 3: Verify the result.
The calculated value is 9800.
Final Answer: \[\boxed{9800}\]