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.

Options

• 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.

Answer 1

Assertion (A) is True and Reason (R) is False.

Explanation:

The ROUND() function in SQL is used to round a number to a given number of decimal places. It is a mathematical function that accepts a numeric value as input and returns a numeric result. For example, ROUND(123.567, 2) gives 123.57. Therefore, the assertion is correct, but the reason is incorrect.