Evaluate the following SQL commands: The command to create a table fails. Identify the
reason for the SQL statement failure? (Choose all that apply.)
A.
You cannot use ORD_NO and ITEM_NO columns as a composite primary key because
ORD NO is also the FOREIGN KEY.
B.
You cannot use SYSDATE in the condition of a CHECK constraint.
C.
You cannot use the BETWEEN clause in the condition of a CHECK constraint.
D.
You cannot use the NEXTVAL sequence value as a DEFAULT value for a column.
Explanation: