ocp 11g认证考试题：1Z0-051-077题
来源：优技教育
ocp 11g认证考试题：1Z0-051-077题，完整题库请点击这里联系老师咨询了解
77. In the CUSTOMERS table, the CUST_CITY column contains the value 'Paris' for the
CUST_FIRST_NAME 'ABIGAIL'.
Evaluate the following query:
SQL> SELECT INITCAP(cust_first_name ' '
UPPER(SUBSTR(cust_city,-LENGTH(cust_city),2)))
FROM customers
WHERE cust_first_name = 'ABIGAIL';
What would be the outcome?
A. Abigail PA
B. Abigail Pa
C. Abigail IS
D. an error message
Answer: B
答案解析：
此为嵌套函数，由里到外可知：
LENGTH(cust_city)=LENGTH('Paris')=5
SUBSTR(cust_city,-5,2)=从右往左第5个，在顺着输出2个字符，即Pa
UPPER(Pa)=PA
INITCAP(cust_first_name ' ' UPPER(SUBSTR(cust_city,-LENGTH(cust_city),2)))=INITCAP('ABIGAIL' '' 'PA')=Abigail Pa
即选B。
精华阅读