Question: Which of the following is a valid SQL statement? a. CREATE TABLE tablel (col1 NUMBER PRIMARY KEY, col2 VARCHAR2 (20) PRIMARY KEY, col3 DATE DEFAULT

Which of the following is a valid SQL statement?
a. CREATE TABLE tablel
    (col1 NUMBER PRIMARY KEY,
    col2 VARCHAR2 (20) PRIMARY KEY,
    col3 DATE DEFAULT SYSDATE,
      col4 VARCHAR2 (2));

b. CREATE TABLE tablel
    (col1 NUMBER PRIMARY KEY,
    col2 VARCHAR2(20),
    col3 DATE,
    col4 VARCHAR2 (2) NOT NULL,
    CONSTRAINT tablel_col3_ck
      CHECK (col3=SYSDATE));

c. CREATE TABLE tablel
   (col1 NUMBER,
   col2 VARCHAR2 (20),
   col3 DATE,
   col4 VARCHAR2 (2),
   PRIMARY KEY (coll));

d. CREATE TABLE tablel
    (coll NUMBER,
    col2 VARCHAR2 (20),
    col3 DATE DEFAULT SYSDATE,
    col4 VARCHAR2 (2);

Step by Step Solution

3.46 Rating (172 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

c CREATE TABLE tablel ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (2 attachments)

PDF file Icon

1803_60b8c12122838_716086.pdf

180 KBs PDF File

Word file Icon

1803_60b8c12122838_716086.docx

120 KBs Word File

Students Have Also Explored These Related Oracle 12c SQL Questions!