1z0-882: MySQL 5.6 Developer Table Practice Questions

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?

• AA. SELECT UPPER (Location) as location FROM MemberLocation
• BB. SELECT UPPER (BINARY location) as location FROM MemberLocation
• CC. SELECT UPPER (location AS UPPER ) as location FROM Memberlocation
• DD. SELECT CONVERT (Location AS UPPER ) as location FROM memberlocation

A statement exists that can duplicate the definition of the ‘world’table. What is missing? CREATE TABLE t1 world

• AA. FROM
• BB. USING
• CC. COPY
• DD. LIKE