KillTest professional provides 11g 1Z0-052 the newest Q&A, completely covers 1Z0-052 test original topic. With our completed 11g resources, you will minimize your 11g cost and be ready to pass your 1Z0-052 test on Your First Try, 100% Money Back Guarantee included!
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));
The above command fails when executed. What could be the reason?
A.SYSDATE cannot be used with the CHECK constraint.
B.The BETWEEN clause cannot be used for the CHECK constraint.
C.The CHECK constraint cannot be placed on columns having the DATE data type.
D.ORD_NO and ITEM_NO cannot be used as a composite primary key because ORD_NO is also the FOREIGN KEY.
Killtest Practice Exams for 1Z0-052 are written to the highest standards of technical accuracy, provided by our certified subject matter experts and published authors for development.