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.

Show Hint

Use ROUND() for numbers; use functions like LEFT(), RIGHT(), or SUBSTRING() for strings.
Updated On: July 22, 2025
  • Both Assertion (A) and Reason (R) are True and Reason (R) is the correct explanation for Assertion (A).
  • Both Assertion (A) and Reason (R) are True and Reason (R) is not the correct explanation for Assertion (A).
  • Assertion (A) is True and Reason (R) is False.
  • Assertion (A) is False, but Reason (R) is True.
Hide Solution
collegedunia
Verified By Collegedunia

The Correct Option is C

Solution and Explanation

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.
Was this answer helpful?
0
0

Top Questions on SQL Queries

View More Questions

CBSE CLASS XII Notification