Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 9 of 24

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'.