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
Evaluate the following SQL statements:Exhibit:Exhibit:The above command fails when executed. What could be the reason?
-
- Site Admin
- Posts: 899559
- Joined: Mon Aug 02, 2021 8:13 am