Question

Assertion (A) : The ROUND() function in SQL can be used to round off a number to a specified number of decimal places.
Reason (R) : The ROUND() function is a string function that accepts character values as input and returns numerical values as output.

• A. Both Assertion (A) and Reason (R) are True and Reason (R) is the correct explanation for Assertion (A).
• B. Both Assertion (A) and Reason (R) are True and Reason (R) is not the correct explanation for Assertion (A).
• C. Assertion (A) is True and Reason (R) is False.
• D. Assertion (A) is False, but Reason (R) is True.

Hint:

Use ROUND() for numbers; use functions like LEFT(), RIGHT(), or SUBSTRING() for strings.

Answer 1

The Correct Option is C

In SQL, the ROUND() function is used to round a numeric value to a specified number of decimal places.
For example, ROUND(123.456, 2) returns 123.46.
Therefore, the Assertion is true.
However, the Reason is incorrect because ROUND() is not a string function.
It works on numeric values, not on character values.
It does not accept strings but accepts numbers.
Therefore, Reason (R) is false.
So, Assertion (A) is true and Reason (R) is false.