Q148 Examine the data in the CUST_NAME column of the CUSTOMERS table

Q148 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

6 rows selected.

You want to display the CUST_NAME values where the last name starts with Mc or MC

Which two WHRE clauses give the required result?

• A) WHERE SUBSTR(cust_name, INSTR(cust_name, ‘ ‘) + 1 ) LIKE ‘Mc%’
• B) WHERE SUBSTR(cust_name, INSTR(cust_name, ‘ ‘) + 1 ) LIKE ‘Mc%’ OR ‘MC%’
• C) WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name, ‘ ‘) + 1)) LIKE ‘Mc%’
• D) WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name, ‘ ‘) + 1)) IN (‘MC%’, ‘Mc%’)
• E) WHERE UPPER(SUBSTR(cust_name, INSTR(cust_name, ‘ ‘) + 1)) LIKE UPPER(‘MC%’)