​Structure of the ORDERITEMS Table

question 11

Multiple Choice

​Structure of the ORDERITEMS table

-If a PRIMARY KEY constraint,named ORDERITEMS_PK,for the ORDER# and ITEM# columns of the ORDERITEMS table have been disabled,which of the following commands will enable the constraint?​

• A) ALTER TABLE orderitems ENABLE PRIMARY KEY CONSTRAINT;
• B) ALTER TABLE orderitems ENABLE CONSTRAINT orderitems_pk;
• C) ALTER TABLE orderitems MODIFY PRIMARY KEY CONSTRAINT;
• D) ​ALTER TABLE orderitems MODIFY PRIMARY KEY CONSTRAINT ENABLE;

---

Definitions:

Demand

The quantity of a good or service that consumers are willing and able to purchase at various prices during a given time period.

Perfectly Inelastic

Refers to a scenario in which the amount demanded or supplied shows no reaction whatsoever to changes in price.

Total Revenue

The total amount of money earned by a business from the sale of its goods and services.

Price-elastic

Refers to the responsiveness of demand or supply to changes in price, with high elasticity indicating significant response to price changes.