ocp 11g¿¼Ìâ´óÈ«£º1Z0-051-084Ì⣬ÍêÕûÌâ¿âÇëµã»÷ÕâÀïÁªÏµÀÏʦ×ÉѯÁ˽â

84. View the Exhibit and examine the structure of the EMPLOYEES table.

Examine the data in the ENAME and HIREDATE columns of the EMPLOYEES table:

ENAME HIREDATE

SMITH 17-DEC-80

ALLEN 20-FEB-81

WARD 22-FEB-81

You want to generate a list of user IDs as follows:

USERID

Smi17DEC80

All20FEB81

War22FEB81

You issue the following query:

SQL>SELECT CONCAT(SUBSTR(INITCAP(ename),1,3), REPLACE(hiredate,'-')) "USERID" FROM employees;

What is the outcome?

A. It executes successfully and gives the correct output.

B. It executes successfully but does not give the correct output.

C. It generates an error because the REPLACE function is not valid.

D. It generates an error because the SUBSTR function cannot be nested in the CONCAT function.

Answer: A

ÊÔÌâ½âÎö£º

ÌâÒâÊä³öµÄÒªÇóÊÇÃû×ÖµÄÇ°Èýλ²¢ÇÒÊ××Öĸ´óд£¬ÈÕÆÚ²»Òª¶ÌºáÏß¡£