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

MySQL Functions — Question 9

Back to all questions
9
Question

Question 3(iii)

What will be the output of following code ?

mysql> SELECT UCASE('Computer studies');
Answer
Output
+---------------------------+
| UCASE('Computer studies') |
+---------------------------+
| COMPUTER STUDIES          |
+---------------------------+
Explanation

The UCASE() function in SQL is used to convert all characters of a given string to uppercase. In this query, UCASE('Computer studies') converts the entire string to 'COMPUTER STUDIES'. Therefore, the output is 'COMPUTER STUDIES'.