Question

Which of the following are text functions? (A) MID()
(B) INSTR()
(C) SUBSTR()
(D) LENGTH()

• A. (A), (B) and (D) only
• B. (A), (B) and (C) only
• C. (A), (B), (C) and (D)
• D. (B), (C) and (D) only

Hint:

String functions include \texttt{LENGTH()}, \texttt{UPPER()}, \texttt{LOWER()}, \texttt{SUBSTR()}, \texttt{INSTR()}, etc. Useful for text manipulation.

Answer 1

The Correct Option is C

Step 1: Recall definitions of text functions.
- MID(): Extracts substring from text (like SUBSTR).
- INSTR(): Returns the position of a substring within a string.
- SUBSTR(): Extracts part of a string.
- LENGTH(): Returns length of string.

Step 2: Conclusion.
All four functions (MID, INSTR, SUBSTR, LENGTH) are text/string functions.
Final Answer: \[ \boxed{(A), (B), (C) \text{ and } (D)} \]