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() 

+ Answer
+ Report
Total Preview: 16827

Copyright © 2024. Powered by Intellect Software Ltd