Question

Match List-I with List-II:

List-I	List-II
(A) group by	(III) having
(B) mid()	(IV) text function
(C) count()	(II) aggregate function
(D) mod()	(I) math function

• A. (A)-(III), (B)-(IV), (C)-(II), (D)-(I)
• B. (A)-(I), (B)-(III), (C)-(II), (D)-(IV)
• C. (A)-(II), (B)-(IV), (C)-(I), (D)-(III)
• D. (A)-(III), (B)-(IV), (C)-(II), (D)-(I)

Hint:

Remember: \textbf{Aggregate functions} summarize data (COUNT, SUM), \textbf{text functions} work on strings (MID), and \textbf{math functions} handle numbers (MOD).

Answer 1

The Correct Option is A

Step 1: Identify function purposes.
- group by: Statement for grouping rows, used with the having clause → (III).
- mid(): String manipulation function for extracting substrings → (IV) text function.
- count(): Aggregate function for row or value counting → (II).
- mod(): Mathematical function returning the remainder → (I).

Step 2: Establish correct pairings.
(A) corresponds to (III), (B) to (IV), (C) to (II), and (D) to (I).
Final Answer: \[\boxed{(A)-(III), (B)-(IV), (C)-(II), (D)-(I)}\]