1Z0-882 · Question #73
In the office table, the city column is structured as shown: Mysql> show columns from office like city'\G --------------------1. row --------------------- Field: city Type…
Sign in or unlock 1Z0-882 to reveal the answer and full explanation for question #73. The question stem and answer options stay visible for context.
Question
In the office table, the city column is structured as shown:
Mysql> show columns from office like city'\G --------------------1. row --------------------- Field: city Type: enum(paris'.'Amsterdam'.'New York'.'Tokyo') Null: Yes Key:
Default:NULL Extra:
Consider the output of the SELECT query executed on the office table:
Mysql> SELECT DISTINCT city FROM office ORDER BY city:
If the query is written as:
SELECT DISTINCT city FROM office ORDER BY CAST(city AS CHAR) In what order are the rows returned?
Options
- AParis, Amsterdam. New York, Tokyo
- BTokyo, New York, Amsterdam, Paris
- CAmsterdam, New York, Paris, Tokyo
- DTokyo, Paris, New York, Amsterdam
Unlock 1Z0-882 to see the answer
You've previewed enough free 1Z0-882 questions. Unlock 1Z0-882 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.