Question

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

	I		II
(i)	Math function	(a)	COUNT()
(ii)	Aggregate function	(b)	ROUND()
(iii)	Date function	(c)	RIGHT()
(iv)	Text function	(d)	YEAR()

Options

• (i) - (c), (ii) - (d), (iii) - (a), (iv) - (b)

• (i) - (b), (ii) - (a), (iii) - (d), (iv) - (c)

• (i) - (d), (ii) - (b), (iii) - (a), (iv) - (c) 

• (i) - (b), (ii) - (c), (iii) - (d), (iv) - (a)

Answer 1

(i) - (b), (ii) - (a), (iii) - (d), (iv) - (c)

Explanation:

	I		II
(i)	Math function	(b)	ROUND()
(ii)	Aggregate function	(a)	COUNT()
(iii)	Date function	(d)	YEAR()
(iv)	Text function	(c)	RIGHT()