1z0-071 topic 1 question 164

Examine the description of the CUSTOMERS table:

You want to display details of all customers who reside in cities starting with the letter D followed by at least two characters.

Which query can be used?

A.
SELECT * FROM customers WHERE city LIKE ‘D__%’;
B.
SELECT * FROM customers WHERE city = ‘%D__’;
C.
SELECT * FROM customers WHERE city = ‘D__%’;
D.
SELECT * FROM customers WHERE city LIKE ‘D__’;