OCP认证071中文考试题库原题(cuug内部资料)第62题

时间：2022-05-13 来源：

本套题库是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