84. You need to create a table with the following column specifications:
1. Employee ID (numeric data type) for each employee
employee_id number
2. Employee Name, (character data type) which stores the employee name
employee_name varchar2
3. Hire date, to store the date when the employee joined the organization
hire_date timestamp
4. Status (character data type). It should contain the value if no data is entered.
status varchar default enable
5. Resume (character large object [CLOB] data type), which would contain the resume submitted by the employee
resume clob
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)
);
clob类型后面不可以有表示字符数量的修饰
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 1_EMP (
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
);(right)
1. Employee ID (numeric data type) for each employee
employee_id number
2. Employee Name, (character data type) which stores the employee name
employee_name varchar2
3. Hire date, to store the date when the employee joined the organization
hire_date timestamp
4. Status (character data type). It should contain the value if no data is entered.
status varchar default enable
5. Resume (character large object [CLOB] data type), which would contain the resume submitted by the employee
resume clob
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)
);
clob类型后面不可以有表示字符数量的修饰
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 1_EMP (
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
);(right)