本套題庫是OCP考試中的071(中文版)試題，由CUUG整理，如有報考OCP認(rèn)證意向，可以聯(lián)系cuug咨詢老師。

62、請選擇兩項。

查看CUSTOMERS表的說明:

CUSTOMER_ID CUSTOMER_NAME

-------------------- ---------------------------

10 MARK

20 Mandy

30 Mary

40 MARVIN

50 MARTIN

哪兩條SELECT語句將返回以下結(jié)果:

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