Oracle
1Z0-071 · Question #22
1Z0-071 Question #22: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-071 to reveal the answer and full explanation for question #22. The question stem and answer options stay visible for context.
Question
Examine the structure of the members table: Which query can be used to display the last names and city names only for members from the states MO and MI?
Exhibit
Options
- ASELECT last_name, city FROM members WHERE state ='MO' AND state ='MI';
- BSELECT last_name, city FROM members WHERE state LIKE 'M%';
- CSELECT last_name, city FROM members WHERE state IN ('MO', 'MI');
- DSELECT DISTINCT last_name, city FROM members WHERE state ='MO' OR state
Unlock 1Z0-071 to see the answer
You've previewed enough free 1Z0-071 questions. Unlock 1Z0-071 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.