Identify the reason for the SQL statement failure?

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: