​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 ensure that the value entered for the MINRETAIL column is less than the value entered for the MAXRETAIL column?​

A) ALTER TABLE promotion
MODIFY CHECK ( minretail < maxretail) ;
B) ALTER TABLE promotion
ADD CHECK ( minretail < maxretail) ;
C) ​ALTER TABLE promotion
MODIFY MINRETAIL CHECK ( < maxretail) ;
D) ​ALTER TABLE promotion
ADD CHECK minretail < maxretail;