ocp 11g认证考试题：1Z0-051-079题
来源：优技教育
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 是一个字符文字，则必须将其放在单引号内)
精华阅读