Which statement is true regarding the execution of the above SQL commands?

Examine the following SQL commands: Which statement is true regarding the execution of
the above SQL commands?

A.
The second CREATE TABLE command generates an error because the CHECK
constraint is not valid.

B.
The first CREATE TABLE command generates an error because CHECK and PRIMARY
KEY constraints cannot be used for the same column.

C.
The first CREATE TABLE command generates an error because the NULL constraint is
not valid.

D.
Both commands execute successfully.

E.
The first CREATE TABLE command generates an error because the column PROD_ID

cannot be used in the PRIMARY KEY and FOREIGN KEY constraints.