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);
Why B is not correct?
Because the table name can’t start with a letter.
number, sorry 😉
Oh ya Thanks:)
Why c is incorrect?
in DEFAULT “ACTIVE” is given in double quotes it should be in single quotes
NUMBER should have parameter ryt?
‘A’ is incorrect because you cannot declare a CLOB variable by specifiying its length.
A. incorrect CLOB lenght resume CLOB(200)
B. incorrect table_name start with number 1_EMP
C. incorrect double quote “ACTIVE”