What is the final output of the following nested function? SELECT…
2026
What is the final output of the following nested function?
SELECT LENGTH(TRIM(' MySQL '));
- A.
5
- B.
6
- C.
7
- D.
11
Attempted by 298 students.
Show answer & explanation
Correct answer: A
The TRIM function removes leading and trailing spaces from ' MySQL ', resulting in the string 'MySQL'. The LENGTH function counts the characters in 'MySQL', which is 5.