本套题库是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
CUUG 优技培训
金牌讲师
实操环境
院校合作
学校新闻
行业新闻
请输入您的手机号
申请试听