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