14、choose one
Examine the description of the CUSTOMERS table:
name null? type
------------------------
CUST_ID NOT NULL VARCHAR2(6)
FIRST_NAME VARCHAR2(50)
LAST_NAME NOT NULL VARCHAR2(50)
ADDRESS VARCHAR2(50)
CITY VARCHAR2(50)
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_%’;
Source : cuug