83.Examine the data in the CUST_NAME column of the CUSTOMERS table.

83.Examine the data in the CUST_NAME column of the CUSTOMERS table.

CUST_NAME
Lex De Haan
Renske Ladwig
Jose Manuel Urman
Jason Mallin

You want to extract only those customer names that have three names and display the * symbol in place
of the first name as follows:

CUST NAME
*** De Haan
**** Manuel Urman

Which two queries give the required output? (Choose two.)
A.SELECT LPAD(SUBSTR(cust_name,INSTR(cust_name,' ')),LENGTH(cust_name),'*') "CUST NAME" FROM customers
WHERE INSTR(cust_name, ' ',1,2)<>0;
B.SELECT LPAD(SUBSTR(cust_name,INSTR(cust_name,' ')),LENGTH(cust_name),'*') "CUST NAME" FROM customers
WHERE INSTR(cust_name, ' ',-1,2)<>0;
C.SELECT LPAD(SUBSTR(cust_name,INSTR(cust_name,' ')),LENGTH(cust_name)- INSTR(cust_name,' '),'*') "CUST NAME"
FROM customers
WHERE INSTR(cust_name, ' ',-1,-2)<>0;
D.SELECT LPAD(SUBSTR(cust_name,INSTR(cust_name,' ')),LENGTH(cust_name)-INSTR(cust_name,' '),'*') "CUST NAME"
FROM customers
WHERE INSTR(cust_name, ' ',1,2)<>0 ;
答案：AB
解析：length应该是总长度，排除CD