Question

With respect to SQL, match the function given in column-II with categories given in column-I :

• A. (i)-(c), (ii)-(d), (iii)-(a), (iv)-(b)
• B. (i)-(b), (ii)-(a), (iii)-(d), (iv)-(c)
• C. (i)-(d), (ii)-(b), (iii)-(a), (iv)-(c)
• D. (i)-(b), (ii)-(c), (iii)-(d), (iv)-(a)

Hint:

COUNT() and SUM() are aggregate functions, ROUND() is a math function, RIGHT() is a text function, YEAR() is for dates.

Answer 1

The Correct Option is B

Let us match each function with the correct category.
ROUND() is a math function because it rounds numeric values.
COUNT() is an aggregate function because it counts rows or non-null values.
YEAR() is a date function because it extracts the year part from a date value.
RIGHT() is a text function because it extracts characters from the right side of a string.
So the correct matching is: (i)-(b), (ii)-(a), (iii)-(d), (iv)-(c).
Therefore, the correct option is (B).