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

MySQL Functions — Question 8

Back to all questions
8
Question

Question 3(ii)

What will be the output of following code ?

mysql> SELECT LCASE('INFORMATICS PRACTICES CLASS 11TH');
Answer
Output
+-------------------------------------------+
| LCASE('INFORMATICS PRACTICES CLASS 11TH') |
+-------------------------------------------+
| informatics practices class 11th          |
+-------------------------------------------+
Explanation

The LCASE() function in SQL is used to convert all characters of a given string to lowercase. In the query, LCASE('INFORMATICS PRACTICES CLASS 11TH') converts the entire string to 'informatics practices class 11th'. Therefore, the output is 'informatics practices class 11th'.