Question

Which CREATE TABLE statement is valid?

Select one:

a. CREATE TABLE ord_details
(ord_no NUMBER(2),
item_no NUMBER(3),
ord_date DATE DEFAULT NOT NULL,
CONSTRAINT ord_uq UNIQUE (ord_no),
CONSTRAINT ord_pk PRIMARY KEY (ord_no));

b. CREATE TABLE ord_details
(ord_no NUMBER(2) PRIMARY KEY,
item_no NUMBER(3) PRIMARY KEY,
ord_date DATE NOT NULL);

c. CREATE TABLE ord_details
(ord_no NUMBER(2) UNIQUE, NOT NULL,
item_no NUMBER(3),
ord_date DATE DEFAULT SYSDATE NOT NULL);

d. CREATE TABLE ord_details
(ord_no NUMBER(2),
item no NUMBER(3),
ord_date DATE DEFAULT SYSDATE NOT NULL,
CONSTRAINT ord_pk PRIMARY KEY (ord no item_no));​

Answer 1

Answer:

CREATE TABLE ord_details  

(ord_no NUMBER(2),  

item_no NUMBER(3),  

ord_date DATE DEFAULT SYSDATE NOT NULL,  

CONSTRAINT ord_pk PRIMARY KEY (ord_no,item_no));

Explanation: