​Structure of the PROMOTION Table

question 51

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;

---

Definitions:

Empty Nest Syndrome

A feeling of sadness or emotional distress affecting parents when their children leave home for the first time.

Parkinson's Disease

A degenerative disorder of the central nervous system that often impairs motor skills, speech, and other functions.

Impaired Immune

A condition in which the body's immune system is not functioning properly, leading to increased susceptibility to infections.

Stillbirth

The death of a fetus at or after the 20th week of pregnancy.