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');
Answer: C. MYSys — First, SUBSTR('MyKid', 1, 2) extracts the first two characters from 'MyKid', resulting in 'My'. Next, UPPER('My') converts the substring to uppercase,…
- A.
mysys
- B.
MySys
- C.
MYSys
- D.
YKSys
Attempted by 681 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'.
Loading lesson…