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

Question

​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;

Quizplus · Accepted Answer

The ADD CHECK statement adds a new check constraint to the table. In this case, we want to ensure that the value entered for the MINRETAIL column is less than the value entered for the MAXRETAIL column, so we need to add a check constraint that enforces this rule. The correct syntax is ADD CHECK (condition), where "condition" is the rule that must be enforced. In this case, the condition is "minretail < maxretail". Therefore, the correct statement is ALTER TABLE promotion ADD CHECK (minretail < maxretail).

​Structure of the PROMOTION Table

Structure of the PROMOTION Table