Trim removes trailing and leading blank spaces

Trim removes trailing and leading blank spaces

• A. IN
• B. Between
• C. Trim
• D. COALESCE

Answer: (C)

Trimming whitespace focuses on cleaning up strings by removing spaces at both ends. The TRIM function is designed to do exactly that: it returns the string with leading and trailing whitespace removed. For example, TRIM(' data ') yields 'data'. Some databases also support removing specific characters or trimming from just one side with variants like LTRIM or RTRIM, but the default Trim removes spaces on both sides. The other options don’t modify the string contents; IN and BETWEEN are comparison operators used in filtering, and COALESCE returns the first non-null value among its arguments. Therefore Trim is the correct choice.

Trimming whitespace focuses on cleaning up strings by removing spaces at both ends. The TRIM function is designed to do exactly that: it returns the string with leading and trailing whitespace removed. For example, TRIM(' data ') yields 'data'. Some databases also support removing specific characters or trimming from just one side with variants like LTRIM or RTRIM, but the default Trim removes spaces on both sides. The other options don’t modify the string contents; IN and BETWEEN are comparison operators used in filtering, and COALESCE returns the first non-null value among its arguments. Therefore Trim is the correct choice.