Evaluate the following SQL statements: Exhibit: Exhibit: The above command fails when
executed. What could be the reason?
A.
The BETWEEN clause cannot be used for the CHECK constraint
B.
SYSDATE cannot be used with the CHECK constraint
C.
ORD_NO and ITEM_NO cannot be used as a composite primary key because ORD_NO
is also the FOREIGN KEY
D.
The CHECK constraint cannot be placed on columns having the DATE data type
Explanation:
SYSDATE cannot be used with the CHECK constraint
http://stackoverflow.com/questions/5332562/using-date-in-a-check-constraint-oracle