大數據就業實戰培訓 Oracle就業實戰培訓
Oracle OCP 19c 認證1Z0-082考試題庫(第14題)-CUUG內部學員版082題庫解析
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_%’;
