Oracle
1Z0-047 · Question #259
1Z0-047 Question #259: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-047 to reveal the answer and full explanation for question #259. The question stem and answer options stay visible for context.
Question
Evaluate the following CREATE TABLE commands: CREATE TABLE orders (ord_no NUMBER(2) CONSTRAINT ord_pk PRIMARY KEY, ord_date DATE, cust_id NUMBER(4)); CREATE TABLE ord_items (ord_no NUMBER(2), item_no NUMBER(3), qty NUMBER(3) CHECK (qty BETWEEN 100 AND 200), expiry_date date CHECK (expiry_date > SYSDATE), CONSTRAINT it_pk PRIMARY KEY (ord_no,item_no), CONSTRAINT ord_fk FOREIGN KEY(ord_no) REFERENCES orders(ord_no)); Why would the ORD_ITEMS table not get created?
Options
- ASYSDATE cannot be used with the CHECK constraint.
- BThe CHECK constraint cannot be used twice for the same table.
- CThe BETWEEN clause cannot be used for the CHECK constraint.
- DORD_NO and ITEM_NO cannot be used as a composite primary key because ORD_NO is also the
Unlock 1Z0-047 to see the answer
You've previewed enough free 1Z0-047 questions. Unlock 1Z0-047 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.