Which function extracts a substring from the middle of a text string given a starting position and length?

• A. Mid
• B. Left
• C. Right
• D. Substring

Answer: (A)

This tests how to pull a portion of a string by specifying where to start and how many characters to take. The Mid function does exactly that: it returns a substring starting at a given position and continuing for a specified length. In many environments, you would call it with something like MID(text, start_num, num_chars), which directly matches “starting position and length” to extract the middle part of the string. Left and Right, by contrast, grab characters from the ends (leftmost or rightmost) and don’t use a middle starting point. Substring exists in various languages as well, but the wording here aligns with Mid, making it the best fit for extracting a middle portion with a defined start and length.