OCP 11g认证题库详解：1Z0-051-079题
最新学讯：近期OCP认证正在报名中，因考试人员较多请尽快报名获取最近考试时间，报名费用请联系在线老师，甲骨文官方认证，报名从速！
我要咨询OCP 11g认证题库详解：1Z0-051-079题，完整题库请点击这里联系老师咨询了解
79. View the Exhibit and examine the structure of the CUSTOMERS table.
In the CUSTOMERS table, the CUST_LAST_NAME column contains the values 'Anderson' and 'Ausson'.
You issue the following query:
SQL> SELECT LOWER(REPLACE(TRIM('son' FROM cust_last_name),'An','O'))
FROM CUSTOMERS
WHERE LOWER(cust_last_name) LIKE 'a%n';
What would be the outcome?
A. 'Oder' and 'Aus'
B. a n error because the TRIM function specified is not valid
C. a n error because the LOWER function specified is not valid
D. a n error because the REPLACE function specified is not valid
Answer: B
试题解析：
TRIM：截去字符串首字符或尾字符(或者两者都截去)(如果trim_character或trim_source 是一个字符文字，则必须将其放在单引号内)
