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.an error because the TRIM function specified is not valid
C.an error because the LOWER function specified is not valid
D.an error because the REPLACE function specified is not valid
答案:B
解析:trim只能截取开始或者结尾的单个字符
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.an error because the TRIM function specified is not valid
C.an error because the LOWER function specified is not valid
D.an error because the REPLACE function specified is not valid
答案:B
解析:trim只能截取开始或者结尾的单个字符