Oracle
1Z0-882 · Question #73
1Z0-882 Question #73: Real Exam Question with Answer & Explanation
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.