Oracle Database SQL 12c 1z0-071 Exam Practice Test 2

© examsiri.com

Question : 4 of 50

Marks: +1, -0

Evaluate the following CREATE TABLE commands:

The above command fails when executed. What could be the reason?

SYSDATE cannot be used with the CHECK constraint.
The BETWEEN clause cannot be used for the CHECK constraint.
The CHECK constraint cannot be placed on columns having the DATE data type.
ORD_NO and ITEM_NO cannot be used as a composite primary key because ORD_NO is also the FOREIGN KEY.

Go to Question:

Prev Question

Next Question