Examice

Exam 1z0-071 All QuestionsBrowse all questions from this exam

Question 158

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?

SELECT * FROM customers WHERE city LIKE ‘D__%’;

SELECT * FROM customers WHERE city = ‘%D__’;

SELECT * FROM customers WHERE city = ‘D__%’;

SELECT * FROM customers WHERE city LIKE ‘D__’;

Correct Answer: A

To display details of all customers who reside in cities starting with the letter D followed by at least two characters, the correct query should use the SQL LIKE operator with appropriate wildcards. The pattern ‘D__%’ matches any city name that starts with 'D' followed by exactly two characters and then any sequence of characters. Therefore, the correct query is SELECT * FROM customers WHERE city LIKE ‘D__%’;.

Discussion

yaya32Option: A

A is correct

Rik92Option: A

A is correct.

OrakolOption: A

A is correct

greenneemOption: A

I think A should be correct . A. city LIKE ‘D__%’

ogi33Option: A

% is zero or more char so ...

lucemqyOption: A

Definitely A

DarnunOption: A

A is correct

alic_alexOption: A

A is correct