What will be the output of the following MySQL query? SELECT…

2026

What will be the output of the following MySQL query?
SELECT CONCAT(UPPER(SUBSTR('MyKid',1,2)),'Sys');

  1. A.

    mysys

  2. B.

    MySys

  3. C.

    MYSys

  4. D.

    YKSys

Attempted by 354 students.

Show answer & explanation

Correct answer: C

First, SUBSTR('MyKid', 1, 2) extracts the first two characters from 'MyKid', resulting in 'My'. Next, UPPER('My') converts the substring to uppercase, producing 'MY'. Finally, CONCAT('MY', 'Sys') combines the strings to yield the final output 'MYSys'.

Explore the full course: Up Lt Grade Assistant Teacher 2025