Q123 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 LIKE ‘D_’;
- (D). SELECT * FROM customers WHERE city = ‘D_%’;
Answer: A