Question

Match List-I with List-II.

List-I	List-II
(A) SUBSTR()	(II) To extract a substring from a string.
(B) TRIM()	(IV) To remove spaces from both sides of the string.
(C) INSTR()	(I) To find the position of a substring in a string.
(D) LEFT()	(III) To extract characters from the left side of the string.

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

Hint:

String functions help manipulate and analyze text: \texttt{SUBSTR()} extracts, \texttt{INSTR()} finds, \texttt{TRIM()} cleans, \texttt{LEFT()} extracts from the left.

Answer 1

The Correct Option is B

Step 1: SUBSTR().
Purpose: To extract a portion of a string → (II).
Step 2: TRIM().
Purpose: To eliminate leading and trailing whitespace from a string → (IV).
Step 3: INSTR().
Purpose: To locate the starting position of a substring within a string → (I).
Step 4: LEFT().
Purpose: To extract characters from the beginning (left side) of a string → (III).
Final Answer: \[\boxed{(A)-(II), (B)-(IV), (C)-(I), (D)-(III)}\]