ocp-047-84 create table

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)