首页 > 其他 > 详细

【2019年8月】OCP 071认证考试最新版本的考试原题-第31题

时间:2019-11-19 09:49:33      阅读:90      评论:0      收藏:0      [点我收藏+]
Choose two

Examine the data in the CUST NAME column of the CUSTOMERS table:

CUST_NAME


Renske Ladwig

Jason Mallin

Samuel McCain

Allan MCEwen

Irene Mikkilineni

Julia Nayer

You want to display the CUST_NAME values where the last name starts with Mc or MC.

Which two WHERE clauses give the required result?

A) WHERE INITCAP (SUBSTR(cust_name, INSTR(cust_name,‘ ‘) +1 ) ) IN (‘MC%‘, ‘Mc%)

B) WHERE UPPER (SUBSTR(cust_nane, INSTR(cust_name, ‘ ‘) +1 ) ) LIKE UPPER(‘MC%‘)

C) WHERE INITCAP(SUBSTR(cust_nane, INSTR(cust_name,‘ ‘) +1 ) ) LIKE ‘Mc%‘

D) WHERE SUBSTR(cust_name,INSTR(cust_name,‘ ‘) +1 ) LIKE ‘Mc%‘ OR ‘MC%‘

E) WHERE SUBSTR(cust_name, INSTR(cust_name,‘ ‘) +1 ) LIKE ‘Mc%‘

Anser:BC

(解析:原来第 66 题,此题的变化是多了 Answer:B。注意 instr 和 substr 的用法,没有实验还是很难理解的。

Answer:C

【2019年8月】OCP 071认证考试最新版本的考试原题-第31题

原文:https://blog.51cto.com/13854012/2451418

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!