PL/SQL :: Basic Concepts - Discussion
Home > PL/SQL > Basic Concepts > MCQs Questions Discussion
32 / 41
Choose the correct option.
Which CREATE TABLE statement is valid?
ACREATE TABLE ord_details(ord_no NUMBER(2) PRIMARY KEY, item_no NUMBER(3) PRIMARY KEY, ord_date DATE NOT NULL);
BCREATE TABLE ord_details (ord_no NUMBER(2) UNIQUE, NOT NULL, item_no NUMBER(3), ord_date DATE DEFAULT SYSDATE NOT NULL);
CCREATE 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));
DCREATE 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: Option (Login/Signup)
Show Explanation
Asked In ::
No Discussion on this question yet!