itgle.com
单选题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？（）AIt would be created only if a uniqu
题目
单选题
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.