Which is the correct syntax to create this table?

Resume (character large object [CLOB] data type), which contains the resume submitted by the
employee
Which is the correct syntax to create this table?

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



Leave a Reply 9

Your email address will not be published. Required fields are marked *


abi

abi

Why B is not correct?

ser

ser

Because the table name can’t start with a letter.

ser

ser

number, sorry 😉

abi

abi

Oh ya Thanks:)

Sasi

Sasi

Why c is incorrect?

arya

arya

in DEFAULT “ACTIVE” is given in double quotes it should be in single quotes

Innez

Innez

NUMBER should have parameter ryt?

Ritam Tiwari

Ritam Tiwari

‘A’ is incorrect because you cannot declare a CLOB variable by specifiying its length.

Anand

Anand

A. incorrect CLOB lenght resume CLOB(200)
B. incorrect table_name start with number 1_EMP
C. incorrect double quote “ACTIVE”