Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
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?
A.
SELECT UPPER (Location) as location FROM MemberLocation
B.
SELECT UPPER (BINARY location) as location FROM MemberLocation
C.
SELECT UPPER (location AS UPPER ) as location FROM Memberlocation
D.
SELECT CONVERT (Location AS UPPER ) as location FROM memberlocation
Answer is A.The default is utf8mb4. Mysql>select Upper(' ');
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
ekpo
2 years, 10 months ago