​Structure of the PROMOTION Table

Multiple Choice

​Structure of the PROMOTION table

-Based on the structure of the PROMOTION table,which of the following commands will add a PRIMARY KEY constraint to the GIFT column?​

A) CREATE TABLE promotion
(gift VARCHAR2(15) PRIMARY KEY,
Minretail NUMBER(5,2) ,
Maxretail NUMBER(5,2) ) ;
B) ALTER TABLE promotion
ADD PRIMARY KEY(gift) ;
C) ​ALTER TABLE promotion
MODIFY (gift PRIMARY KEY) ;
D) ​none of the above