Choose two Examine the data in the CUST NAME column of the CUSTOMERS table: CUST_NAME ------------------------------
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
--结束END--
本文标题: 【2019年8月】OCP 071认证考试最新版本的考试原题-第31题
本文链接: https://www.lsjlt.com/news/2400.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-16
2024-05-16
2024-05-16
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0