OCP-1Z0-051-V9.02-77题

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

 答案解析：

参考： http://blog.youkuaiyun.com/rlhua/article/details/12848395

此为嵌套函数，由里到外可知：

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。