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 KE
Y);
D) none of the above

Question

​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 KE
Y); 
D) ​none of the above

Quizplus · Accepted Answer

Option B will add a PRIMARY KEY constraint to the GIFT column in the PROMOTION table. Option A is already adding a PRIMARY KEY constraint to the gift column, but it does not match the existing structure of the PROMOTION table. Option C is not a valid syntax to add a PRIMARY KEY constraint.

​Structure of the PROMOTION Table

Structure of the PROMOTION Table