The SQL statement SELECT ROUND (65.726, -1) FROM DUAL; prints
2023
The SQL statement SELECT ROUND (65.726, -1) FROM DUAL; prints
- A.
70
- B.
garbage
- C.
726
- D.
More than one of the above
- E.
None of the above
Attempted by 1008 students.
Show answer & explanation
Correct answer: A
The ROUND function in SQL rounds a number to a specified number of decimal places. When the second argument is negative, it rounds to the nearest 10, 100, etc. In this case, ROUND(65.726, -1) rounds to the nearest 10. Since 65.726 is closer to 70 than to 60, the result is 70.