OCP-1Z0-051-题目解析-第25题
来源:互联网 发布:指南针证券分析软件 编辑:程序博客网 时间:2024/05/22 04:48
25. You need to create a table with the following column specifications:
1. Employee ID (numeric data type) for each employee
2. Employee Name (character data type) that stores the employee name
3. Hire date, which stores the date of joining the organization for each employee
4. Status (character data type), that contains the value 'ACTIVE' if no data is entered
5. Resume (character large object [CLOB] data type), which contains the resume submitted by the employee
Which is the correct syntax to create this table?
A.
CREATE TABLE EMP_1
(emp_id NUMBER(4),
emp_name VARCHAR2(25),
start_date DATE,
e_status VARCHAR2(10) DEFAULT 'ACTIVE',
resume CLOB(200));
B.
CREATE TABLE 1_EMP
(emp_id NUMBER(4),
emp_name VARCHAR2(25),
start_date DATE,
emp_status VARCHAR2(10) DEFAULT 'ACTIVE',
resume CLOB);
C.
CREATE TABLE EMP_1
(emp_id NUMBER(4),
emp_name VARCHAR2(25),
start_date DATE,
emp_status VARCHAR2(10) DEFAULT "ACTIVE",
resume CLOB);
D.
CREATE TABLE EMP_1
(emp_id NUMBER,
emp_name VARCHAR2(25),
start_date DATE,
emp_status VARCHAR2(10) DEFAULT 'ACTIVE',
A:错误,CLOB类型不需要定义长度
B:错误,表名不能以数字开头
C:错误,字符串是以单引号开头和结束的
D:正确
1. Employee ID (numeric data type) for each employee
2. Employee Name (character data type) that stores the employee name
3. Hire date, which stores the date of joining the organization for each employee
4. Status (character data type), that contains the value 'ACTIVE' if no data is entered
5. Resume (character large object [CLOB] data type), which contains the resume submitted by the employee
Which is the correct syntax to create this table?
A.
CREATE TABLE EMP_1
(emp_id NUMBER(4),
emp_name VARCHAR2(25),
start_date DATE,
e_status VARCHAR2(10) DEFAULT 'ACTIVE',
resume CLOB(200));
B.
CREATE TABLE 1_EMP
(emp_id NUMBER(4),
emp_name VARCHAR2(25),
start_date DATE,
emp_status VARCHAR2(10) DEFAULT 'ACTIVE',
resume CLOB);
C.
CREATE TABLE EMP_1
(emp_id NUMBER(4),
emp_name VARCHAR2(25),
start_date DATE,
emp_status VARCHAR2(10) DEFAULT "ACTIVE",
resume CLOB);
D.
CREATE TABLE EMP_1
(emp_id NUMBER,
emp_name VARCHAR2(25),
start_date DATE,
emp_status VARCHAR2(10) DEFAULT 'ACTIVE',
resume CLOB);
A:错误,CLOB类型不需要定义长度
B:错误,表名不能以数字开头
C:错误,字符串是以单引号开头和结束的
D:正确
0 0
- OCP-1Z0-051-题目解析-第25题
- OCP-1Z0-051-题目解析-第1题
- OCP-1Z0-051-题目解析-第2题
- OCP-1Z0-051-题目解析-第3题
- OCP-1Z0-051-题目解析-第4题
- OCP-1Z0-051-题目解析-第5题
- OCP-1Z0-051-题目解析-第6题
- OCP-1Z0-051-题目解析-第7题
- OCP-1Z0-051-题目解析-第8题
- OCP-1Z0-051-题目解析-第9题
- OCP-1Z0-051-题目解析-第10题
- OCP-1Z0-051-题目解析-第11题
- OCP-1Z0-051-题目解析-第12题
- OCP-1Z0-051-题目解析-第13题
- OCP-1Z0-051-题目解析-第14题
- OCP-1Z0-051-题目解析-第15题
- OCP-1Z0-051-题目解析-第16题
- OCP-1Z0-051-题目解析-第17题
- 网络基础 TCP连接的创建与释放
- Android笔记 之 旋转木马的音乐效果
- div的显示和隐藏
- 关于#include< >与#include" "
- 【好】深入理解javascript闭包
- OCP-1Z0-051-题目解析-第25题
- eclipse快捷键
- 【数字图像处理之(二)】图像的分类
- 猜拳小游戏
- 碰到了开机启动笔记本 发出嘀嘀嘀...的声音的问题之后
- 网民隐私被窃取成牟利工具
- 关于get提交编码问题
- package(dbms_random)随机取时间
- 【学习并改进】黑马程序员-张孝祥-银行业务调度系统