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)
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值