Which query can be used?

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 = ‘D_%’;
B. SELECT * FROM customers WHERE city LIKE ‘D_’;
C. SELECT * FROM customers WHERE city LIKE ‘D_%’;
D. SELECT * FROM customers WHERE city = ‘%D_’;

Download Printable PDF. VALID exam to help you PASS.

3 thoughts on “Which query can be used?

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.