Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 59 of 81

MySQL Functions — Question 10

Back to all questions
10
Question

Question 3(iv)

What will be the output of following code ?

mysql> SELECT CONCAT(LOWER('Class'), UPPER('xii'));
Answer
Output
+--------------------------------------+
| CONCAT(LOWER('Class'), UPPER('xii')) |
+--------------------------------------+
| classXII                             |
+--------------------------------------+
Explanation

In the query, LOWER('Class') converts 'Class' to lowercase, resulting in 'class', and UPPER('xii') converts 'xii' to uppercase, resulting in 'XII'. The CONCAT() function then combines these two results, producing the final output 'classXII'.