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');
- A.
mysys
- B.
MySys
- C.
MYSys
- 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'.