Oracle.1Z0-051.175q(12)

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

B. CREATE TABLE 9emp$# (emp_no NUMBER(4));

C. CREATE TABLE emp*123 (emp_no NUMBER(4));

D. CREATE TABLE emp9$# (emp_no NUMBER(4), date DATE);

Answer: A

QUESTION 27

Which two statements are true regarding tables? (Choose two.)

A. A table name can be of any length.

B. A table can have any number of columns.

C. A column that has a DEFAULT value cannot store null values.

D. A table and a view can have the same name in the same schema.

E. A table and a synonym can have the same name in the same schema.

F. The same table name can be used in different schemas in the same database.

Answer: EF

QUESTION 28

Which two statements are true regarding constraints? (Choose two.)