400-090-9964


专题 | 论坛

教学文章

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

版权所有@北京优技教育技术有限公司(CUUG,中国UNIX用户协会) Copyright 2017 ALL Rights Reserved 京ICP备11008061号-1

CUUG旗下网站:www.cuug.com.cn www.cuug.com oracle.cuug.com bbs.cuug.com bd.cuug.com

电话:010-59426307 010-59426319 邮政编码:100089

海淀校区:北京市海淀区紫竹院路88号紫竹花园4号楼D座703(CUUG)

关闭