Oracle.1Z0-051.175q(15)

OCP 11g 051题库

QUESTION 25

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);

Answer: D

QUESTION 26

Which is the valid CREATE TABLE statement?

A. CREATE TABLE emp9$# (emp_no NUMBER (4));

搜索“diyifanwen.net”或“第一范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，第一范文网，提供最新小学教育Oracle.1Z0-051.175q(15)全文阅读和word下载服务。