Question

Match the following SQL functions/clauses with their descriptions:

SQL Function		Description
P.	MAX()	1.	Find the position of a substring in a string.
Q.	SUBSTRING()	2.	Returns the maximum value in a column.
R.	INSTR()	3.	Sorts the data based on a column.
S.	ORDER BY	4.	Extracts a portion of a string.

विकल्प

• P - 2, Q - 4, R - 3, S - 1

• P - 2, Q - 4, R - 1, S - 3

• P - 4, Q - 3, R - 2, S - 1

• P - 4, Q - 2, R - 1, S - 3

Answer 1

P - 2, Q - 4, R - 1, S - 3

Explanation:

SQL Function		Description
P.	MAX()	2.	Returns the maximum value in a column.
Q.	SUBSTRING()	4.	Extracts a portion of a string.
R.	INSTR()	1.	Find the position of a substring in a string.
S.	ORDER BY	3.	Sorts the data based on a column.