OCP认证071中文考试题库原题(cuug内部资料)第62题
最新学讯：近期OCP认证正在报名中，因考试人员较多请尽快报名获取最近考试时间，报名费用请联系在线老师，甲骨文官方认证，报名从速！
我要咨询本套题库是OCP考试中的071(中文版)试题，由CUUG整理，如有报考OCP认证意向，可以联系cuug咨询老师。
62、请选择两项。
查看CUSTOMERS表的说明:
CUSTOMER_ID CUSTOMER_NAME
-------------------- ---------------------------
10 MARK
20 Mandy
30 Mary
40 MARVIN
50 MARTIN
哪两条SELECT语句将返回以下结果:
CUSTOMER_NAME
---------------------------
Mandy
Mary
A) SELECT customer_name FROM customers WHERE customer_name LIKE '*Ma*';
B) SELECT customer_name FROM customers WHERE UPPER (customer_name) LIKE 'MA*' ;
C) SELECT customer_name FROM customers WHERE customer_name ='*Ma*' ;
D) SELECT customer_name FROM customers WHERE customer_name LIKE 'Ma*' ;
E) SELECT customer_name FROM customers WHERE customer_name LIKE '%a%' ;
F) SELECT customer_name FROM customers WHERE UPPER (customer_name) LIKE 'MA%' ;
G) SELECT customer_name FROM customers WHERE customer_name LIKE 'Ma%';
整理：cuug
