OCP-1Z0-051 第84题 CONCAT，RAPLACE，INITCAP，SUBSTR函数

一、原题

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.

答案：A

二、题目翻译

查看EMPLOYEES表的结构
表中ENAME and HIREDATE两列的数据如下：
ENAME      HIREDATE
SMITH       17-DEC-80
ALLEN       20-FEB-81
WARD        22-FEB-81

现在要生成如下的一个用户ID的列表：
USERID
Smi17DEC80
All20FEB81
War22FEB81

执行下面的查询语句：
SELECT CONCAT(SUBSTR(INITCAP(ename),1,3), REPLACE(hiredate,'-')) "USERID"
FROM employees;
执行结果是什么?
A.执行成功，并且能得出正确的结果。
B.执行成功，但是结果不正确。
C.报错,因为REPLACE无效。
D.报错，因为SUBSTR函数不能被嵌套在CONCAT函数中。