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 number to the nearest place value based on \texttt{n}. - If \texttt{n>0}: rounds to decimal places.
- If \texttt{n = 0}: rounds to nearest integer.
- If \texttt{n<0}: rounds to the left of the decimal.

Step 2: Apply here.
- Number = 9873.567
- Parameter = -2 → round to nearest hundred.
- 9873.567 → the tens digit is 7 (≥ 5), so we round up.
\[ 9873.567 \approx 9800 \]
Step 3: Check options.
Correct value is 9800.
Final Answer: \[ \boxed{9800} \]