ExamQuestions.com

Register
Login
Oracle Datbase 12c SQL Exam Questions

Oracle

Oracle Datbase 12c SQL

33 / 120

Question 33:

Examine the structure of the MEMBERS table. 
image
Which query can be used to display the last names and city names only for members from the states MO and MI? 

Answer options:

A. SELECT last_name, city FROM members WHERE state =`MO` AND state =`MI`;
B. SELECT last_name, city FROM members WHERE state LIKE `M%`;
C. SELECT last_name, city FROM members WHERE state IN (`MO`, `MI`);
D. SELECT DISTINCT last_name, city FROM members WHERE state =`MO` OR state =`MI`;