Informatics Practices
What will be the output of following code ?
mysql> SELECT CONCAT(LOWER('Class'), UPPER('xii'));
Answer
+--------------------------------------+
| CONCAT(LOWER('Class'), UPPER('xii')) |
+--------------------------------------+
| classXII |
+--------------------------------------+
Working
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'.
Related Questions
What will be the output of following code ?
mysql> SELECT LCASE('INFORMATICS PRACTICES CLASS 11TH');What will be the output of following code ?
mysql> SELECT UCASE('Computer studies');If Str = "INFORMATICS PRACTICES …." and Str1 = "… FOR CLASS XI"
Write commands to print the output as 'informatics practices for class xi'
Write commands to display the system date.