Evaluate the CREATE TABLE statement：   CREATE TABLE products   （product_id NUMBER （6）  CONSTRAINT prod_id_pk PRIMARY KEY，  product_name VARCHAR2 （15））；   Which statement is true regarding the PROD_ID_PK constraint？（）

A It would be created only if a unique index is manually created first.

B It would be created and would use an automatically created unique index.

C It would be created and would use an automatically created nonunique index.

D It would be created and remains in a disabled state because no index is specified in the command.