25. You need tocreate 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 submittedby the
employee
Which is thecorrect syntax to create this table?
A. CREATE TABLEEMP_1
(emp_idNUMBER(4),
emp_nameVARCHAR2(25),
start_date DATE,
e_statusVARCHAR2(10) DEFAULT 'ACTIVE',
resumeCLOB(200));
B. CREATE TABLE1_EMP
(emp_idNUMBER(4),
emp_nameVARCHAR2(25),
start_date DATE,
emp_statusVARCHAR2(10) DEFAULT 'ACTIVE',
resume CLOB);
C. CREATE TABLEEMP_1The safer , easier way to help you pass any IT exams.
14 / 99
(emp_idNUMBER(4),
emp_nameVARCHAR2(25),
start_date DATE,
emp_statusVARCHAR2(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);
Answer: D
B的表名以数字开头所有错误。
表名必须以字母开头,由1-30个字符组成,由A-Z a-z 0-9 _ $ #组成,最多有1000个列。