Prev Question
Next Question

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%’;

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *