（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';

B.

SELECT SUBSTR(cust_name, INSTR(cust_name,' ')+1)

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%');

答案：（B）

ITPub博客

OCP 1Z0-051-82