（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 ;

答案：（A、B）

D（X），LPAD第2个参数提供的值不正确

ITPub博客

OCP 1Z0-051-83