本文主要是介绍1z0-071 Oracle Database 12c SQL 第67题 模糊搜索,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!
Q67. Examine the data in the CUST_NAME column of the CUSTOMERS table.
CUST_NAME
-——————
Renske Ladwig
Jason Mallin
Samuel McCain
Allan MCEwen
Irene Mikilineni
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 SUBSTR (cust_name, INSTR (cust_name, ‘ ‘)+1)
LIKE INITCAP (‘MC%’);
B. SELECT SUBSTR (cust_name, INSTR (cust_name, ‘ ‘)+1)
FROM customers
WHERE INITCAP (SUBSTR(cust_name, INSTR (cust_name, ‘ ‘)+1)) = ‘Mc’;
C. SELECT SUBSTR (cust_name, INSTR (cust_name, ‘ ‘)+1)
FROM customers
WHERE INITCAP (SUBSTR(cust_name, INSTR (cust_name, ‘ ‘)+1))
LIKE ‘Mc%’;
D. SELECT SUBSTR (cust_name, INSTR (cust_name, ‘ ‘)+1)
FROM customers
WHERE INITCAP (SUBSTR(cust_name, INSTR (cust_name, ‘ ‘)+1)) = INITCAP ‘MC%’;
Correct Answer: C
这篇关于1z0-071 Oracle Database 12c SQL 第67题 模糊搜索的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!