Oracle Database SQL 12c 1z0-071 Exam Practice Test 1

Question : 19 of 50

Marks: +1, -0

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?

SELECT last_name, city FROM members WHERE state ='MO' AND state ='MI';
SELECT last_name, city FROM members WHERE state LIKE 'M%';
SELECT last_name, city FROM members WHERE state IN ('MO', 'MI');
SELECT DISTINCT last_name, city FROM members WHERE state ='MO' OR state ='MI';

Go to Question:

Prev Question

Next Question