Which CREATE TABLE statement is valid?
Answer options
A
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));
B
CREATE TABLE ord_details (ord_no NUMBER(2), item_no NUMBER(3), ord_date DATE DEFAULT SYSDATE, CONSTRAINT ord_pk);
C
CREATE TABLE ord_details ord_no NUMBER(2), item_no NUMBER(3);
D
CREATE ord_details TABLE (ord_no NUMBER(2));
Correct 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
The statement correctly defines columns, a DEFAULT, NOT NULL, and a composite PRIMARY KEY constraint.