What could be the reason?

Evaluate the following SQL statements: Exhibit: Exhibit: The above command fails when
executed. What could be the reason?

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:



Leave a Reply 2

Your email address will not be published. Required fields are marked *


king

king

SYSDATE cannot be used with the CHECK constraint