OCP-1Z0-051-V9.02-82题
来源:互联网 发布:pop3端口号是多少 编辑:程序博客网 时间:2024/05/24 04:29
82. 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 need to display customers' second names where the second name starts with "Mc" or "MC."
Which query gives the required output?
A. SELECT SUBSTR(cust_name, INSTR(cust_name,' ')+1)
FROM customers
WHERE INITCAP(SUBSTR(cust_name,INSTR(cust_name,' ')+1))='Mc';FROM customers
WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name,' ')+1)) LIKE 'Mc%';
C. SELECT SUBSTR(cust_name, INSTR(cust_name,' ')+1)
FROM customers
WHERE SUBSTR(cust_name, INSTR(cust_name,' ')+1) LIKE INITCAP('MC%');
D. SELECT SUBSTR(cust_name, INSTR(cust_name,' ')+1)
FROM customers
WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name,' ')+1)) = INITCAP('MC%');
Answer: B
答案解析:
参考:http://blog.csdn.net/rlhua/article/details/12848395
题意要求:You need to display customers' second names where the second name starts with "Mc" or "MC."
cust_name由first name和second name组成,中间有空格,要求找出second name以"Mc" or "MC."开头
INSTR(cust_name,' ')找出空格的位置,并返回,这个位置之后的second name的开始。
SUBSTR(cust_name, INSTR(cust_name,' ')+1)找出空格+1的之后的字符,即是找出second name的名字。
INITCAP(SUBSTR(cust_name, INSTR(cust_name,' ')+1)) LIKE 'Mc%' 匹配出 LIKE 'Mc%'or "MC“的字符,使用INITCAP,让其匹配。
故答案选B
- OCP-1Z0-051-V9.02-82题
- OCP-1Z0-051-V9.02-1题
- OCP-1Z0-051-V9.02-1题
- OCP-1Z0-051-V9.02-1题
- OCP-1Z0-051-V9.02-11题
- OCP-1Z0-051-V9.02-12题
- OCP-1Z0-051-V9.02-14题
- OCP-1Z0-051-V9.02-15题
- OCP-1Z0-051-V9.02-17题
- OCP-1Z0-051-V9.02-18题
- OCP-1Z0-051-V9.02-21题
- OCP-1Z0-051-V9.02-118题
- OCP-1Z0-051-V9.02-120题
- OCP-1Z0-051-V9.02-32题
- OCP-1Z0-051-V9.02-33题
- OCP-1Z0-051-V9.02-93题
- OCP-1Z0-051-V9.02-94题
- OCP-1Z0-051-V9.02-95题
- Missian指南二:准备工作
- java中String,Date,Timestamp之间的相互转换
- org.xml.sax.SAXParseException: Content is not allowed in prolog
- iOS 图片压缩
- DAS、NAS、SAN存储技术的比较
- OCP-1Z0-051-V9.02-82题
- iOS7适配之设计篇
- 【Java工程师之路】[2-1.9]数据库视图介绍
- 【笔记】安卓不支持JSON包
- hbase phoenix批量插入数据例子
- 解决eclipse老是检测不到手机设备方法
- 写一个SSDTShadow Hook
- Android PopupWindow 与 软键盘 的遮挡问题解决
- sql语句的执行机制