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