ocp考试资料群：569933648 验证码：ocp OCP 12c 19c考试题库解析与资料群：钉钉群号：35277291
全部博文（487）
分类： Oracle
2019-10-16 09:28:38
choose the best answer
The CUSTOMERS table has a CUST_LAST_NAME column of data type VARCHAR2.
The table has two rows whose COST_LAST_MANE values are Anderson and Ausson.
Which query produces output for CUST_LAST_SAME containing Order for the first row and Aus for the second?
A) SELECT REPLACE (REPLACE(cust_last_name,'son',''),'An','O') FROM customers;
B) SELECT REPLACE (TRIM(TRALING 'son' FROM cust_last_name), 'An','O') FROM customers;
C) SELECT INITCAP (REPLACE(TRIM('son' FROM cust_last_name),'An','O')) FROM customers;
D) SELECT REPLACE (SUBSTR(cust_last_name,-3), 'An', 'O') FROM customers;
Answer：A
(解析：经过测试，A 答案能够打印正确的结果。)
