（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:

SELECT CONCAT(SUBSTR(INITCAP(ename),1,3),

REPLACE(hiredate,'-')) "USERID"

FROM employees;

What is the outcome?

答案：（A）

ITPub博客

OCP 1Z0-051-84