Samuel designs a database for a production company. He creates a table as follows:
CREATE TABLE Product
(Product_No number(10)
CONSTRAINT Prod_Product_No_pk PRIMARY KEY,
Product_ID number(10)
CONSTRAINT prod_Product_ID_nk NOT NULL);
For which column of the table will an index be created?
A.
No index will be created.
B.
An index will be created for the Product_ID column.
C.
An index will be created for the Product_No column.
D.
A unique index will be created for the Product_ID column.