Which of the following statements will produce the value 21.1?
A) SELECT ROUND(21.12,1)FROM dual;
B) SELECT ROUND(21.12,-1)FROM dual;
C) SELECT ROUND(21.12,0)FROM dual;
D) none of the above

Question

Which of the following statements will produce the value 21.1?​
A) ​SELECT ROUND(21.12,1)FROM dual;
B) ​SELECT ROUND(21.12,-1)FROM dual;
C) ​SELECT ROUND(21.12,0)FROM dual;
D) ​none of the above

Quizplus · Accepted Answer

The ROUND function in SQL is used to round a numeric value to a specified precision. The precision is defined by the second argument of the function.

In option A, we have specified a precision of 1 decimal place. The number 21.12 rounded to 1 decimal place will result in 21.1, which is the desired output.

Option B specifies a precision of -1, which means that the number will be rounded to the nearest ten. In this case, the number 21.12 will be rounded to 20.

Option C specifies a precision of 0, which means that the number will be rounded to the nearest whole number. In this case, the number 21.12 will be rounded to 21, which is not equal to the desired output of 21.1.

Therefore, the best choice is A as it will give the desired output of 21.1.

Which of the Following Statements Will Produce the Value 21