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 是一個字符文字，則必須將其放在單引號內)
