Oracle
1Z0-882 · Question #95
Examine the structure and content of the MemberLocation table: You want to have the field location returned in all letters (example: BERLIN). Which query would you use?
The correct answer is A. SELECT UPPER (Location) as location FROM MemberLocation. https://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_upper
SQL Data Manipulation
Question
Examine the structure and content of the MemberLocation table:
You want to have the field location returned in all letters (example: BERLIN). Which query would you use?
Exhibit
Options
- ASELECT UPPER (Location) as location FROM MemberLocation
- BSELECT UPPER (BINARY location) as location FROM MemberLocation
- CSELECT UPPER (location AS UPPER ) as location FROM Memberlocation
- DSELECT CONVERT (Location AS UPPER ) as location FROM memberlocation
How the community answered
(48 responses)- A71% (34)
- B4% (2)
- C8% (4)
- D17% (8)
Explanation
https://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_upper
Topics
#UPPER function#string functions#case conversion#SELECT
Community Discussion
No community discussion yet for this question.