Question:The Employee table uses alphanumeric characters for their Employee ID field, which contains 7 digits prefixed with 3 characters. The alphanumeric characters refer to the department code. You want to generate a list of all the department codes displayed in capital letters. Which function(s) you will use for this query?
A CONCAT()
B SUBSTR()
C UPPER()
D LOWER()
E REPLACE()
+ AnswerC
+ Report