Oracle
1Z0-071 · Question #63
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…
The correct answer is B. SELECT SUBSTR(cust_name, INSTR(cust_name,' ')+1) FROM customers. See the full explanation below for the reasoning.
Question
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?
Options
- ASELECT SUBSTR(cust_name, INSTR(cust_name,' ')+1) FROM customers
- BSELECT SUBSTR(cust_name, INSTR(cust_name,' ')+1) FROM customers
- CSELECT SUBSTR(cust_name, INSTR(cust_name,' ')+1) FROM customers
- DSELECT SUBSTR(cust_name, INSTR(cust_name,' ')+1) FROM customers
How the community answered
(33 responses)- A9% (3)
- B85% (28)
- C3% (1)
- D3% (1)
Community Discussion
No community discussion yet for this question.