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

© examsnet.com

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:

Advertisements