84.View the Exhibit and examine the structure of the EMPLOYEES table.
来源:互联网 发布:淘宝女装店铺 编辑:程序博客网 时间:2024/06/06 06:35
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.
答案:A
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
0 0
- 84.View the Exhibit and examine the structure of the EMPLOYEES table.
- 8.View the Exhibit and examine the structure of the CUSTOMERS table.
- 11.View the Exhibit and examine the structure of the PRODUCTS table.
- 13.View the Exhibit and examine the structure of the PRODUCTS table.
- 44.View the Exhibit and examine the structure of the ORD table.
- 52.View the Exhibit and examine the structure of the PRODUCTS table.
- 54.View the Exhibit and examine the structure of the CUSTOMERS table.
- 56.View the Exhibit and examine the structure of the PROMOTIONS table.
- 61.View the Exhibit and examine the structure of the PROMOTIONS table.
- 63.View the Exhibit and examine the structure of the PRODUCTS table.
- 65.View the Exhibit and examine the structure of the CUSTOMERS table.
- 99.View the Exhibit and examine the structure of the PROMOTIONS table.
- 100.View the Exhibit and examine the structure of the PROMOTIONS table.
- 110.View the Exhibit and examine the structure of the CUSTOMERS table.
- 111.View the Exhibit and examine the structure of the CUSTOMERS table.
- 112.View the Exhibit and examine the structure of the PROMOTIONS table.
- 114.View the Exhibit and examine the structure of the SALES table.
- 115.View the Exhibit and examine the structure of the CUSTOMERS table.
- px像素如何转为dip设备独立像素设备独立像
- python 判断是否为数字(整型,浮点型)
- 蓝桥杯历届-六角填数
- 一步一步学网络爬虫(从python到scrapy)
- PowerDesigner对MySql数据库的Excel导入导出
- 84.View the Exhibit and examine the structure of the EMPLOYEES table.
- 响铃:从苗寨失火事件看公关借势的正确姿势
- sublime text的技巧
- CheckedListBox 当中项的状态改变
- 数据库设计范式
- Activity 的启动模式
- iOS开发 之 可穿戴设备 蓝牙4.0 BLE 开发
- Android布局优化之Merge、Include、ViewStub使用与源码分析
- linux操作系统面试题大全