Which function is used to limit the length of a string to the first eight characters?

• A. LEFT
• B. SUBSTR
• C. CONCAT
• D. TRIM

Answer: (B)

Limiting a string to the first eight characters is done by extracting a substring from the start with a fixed length. SUBSTR does exactly that: it returns a portion of the string starting at a given position and continuing for a specified number of characters. Using SUBSTR(your_string, 1, 8) yields the first eight characters, or the full string if it’s shorter than eight. The other functions don’t perform this task: CONCAT joins strings, and TRIM removes whitespace from ends. While LEFT can also return the first eight in many systems, SUBSTR explicitly demonstrates taking a defined-length portion from the start, which is why it’s the appropriate choice here.