Examine the data in the cusT_NAME column of the cuSTOMERs table:
C UST NAME
------————
Renske Ladwig
Jason Ma11in
Samue1 Mccain
A1lan MCEwen
Irene Mikkilineni
Juiia Nayer
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 UPPER(SUBSTR (cust_name,INSTR(cust_name, '')+1)LIKE UPPER('MC%')
B.WHERE INITCAP (SUBSTR(cust_name, INSTR (cust_name, '1))IN ('MC%', "Mc%)
C.WHERE INITCAP (SUBSTR(cust_name, INSTR(cust_name, '')+1)) LIKE 'MC%'
D.WHERE SUBSTR(cust name, INSTR(cust_name,' ')+ 1)LIKE 'Mc%
E.WHERE SUBSTR (cust_name,INSTR(cust_name,'')+1 ）LIKE 'Mc%'OR'MC%,
正确答案CE 