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?

Question

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?

Accepted Answer

A. SELECT * FROM customers WHERE city LIKE `D_%';

Answer

B. SELECT * FROM customers WHERE city = `%D_';

Answer

C. SELECT * FROM customers WHERE city LIKE `D_';

Answer

D. SELECT * FROM customers WHERE city = `D_%';

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…

Question

Exhibit

Options

How the community answered

Topics

Community Discussion