Which two WHERE clauses give the required result?

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

You want to display the CUST_NAME values where the last name starts with Mc or MC. Which two WHERE clauses give the required result?
A. WHERE SUBSTR (cust_name, INSTR (cust_name, ”) +1) LIKE ‘Mc%’
B. WHERE INITCAP (SUBSTR (cust_name, INSTR(cust_name, ”)+1)) IN (‘MC%’, ‘Mc%)
C. WHERE UPPER (SUBSTR (cust_name, INSTR(cust_name, ”)+1)) LIKE UPPER (‘MC%’)
D. WHERE SUBSTR (cust_name, INSTR (cust_name, ”) +1) LIKE ‘Mc%’ OR ‘MC%’
E. WHERE INITCAP (SUBSTR (cust_name, INSTR(cust_name, ”)+1)) LIKE ‘Mc%’

Download Printable PDF. VALID exam to help you PASS.