MCQ: Advanced SQL Tutorial | String Functions + Use Cases

Select the correct single-word answer.

1. What SQL function removes blank spaces from both the beginning and end of a string?

• LTRIM
• REPLACE
• RTRIM
• TRIM
• Reveal Answer

2. Which SQL function is used to replace a specific sequence of characters within a string with another sequence?

• SUBSTRING
• UPPER
• TRIM
• REPLACE
• Reveal Answer

3. What SQL function extracts a specified number of characters from a string, starting at a given position?

• TRIM
• LOWER
• REPLACE