[Updated] Goldman Sachs Aptitude Test Questions and Answers
Practice List of TCS Digital Coding Questions !!!
Take 50+ FREE!! Online Data Interpretation Mock test to crack any Exams.

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 :: Virtusa

Post Your Answer Here:     

No Discussion on this question yet!