Oracle
1Z0-071 · Question #284
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…
The correct answer is C. SELECT * FROM customers WHERE city LIKE `D_%'. See the full explanation below for the reasoning.
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?
Exhibit
Options
- ASELECT * FROM customers WHERE city = `D_%';
- BSELECT * FROM customers WHERE city LIKE `D_';
- CSELECT * FROM customers WHERE city LIKE `D_%';
- DSELECT * FROM customers WHERE city = `%D_';
How the community answered
(23 responses)- A4% (1)
- B4% (1)
- C83% (19)
- D9% (2)
Community Discussion
No community discussion yet for this question.