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 '));

Answer: A. 5 — The TRIM function removes leading and trailing spaces from ' MySQL ', resulting in the string 'MySQL'. The LENGTH function counts the characters in 'MySQL',…

  1. A.

    5

  2. B.

    6

  3. C.

    7

  4. D.

    11

Attempted by 776 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.

Explore the full course: Niacl Ao It Specialist

Loading lesson…