​Structure of the ORDERITEMS Table

question 50

Multiple Choice

​Structure of the ORDERITEMS table

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

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

---

Definitions:

Subsidiary

A company that is fully or partly owned and wholly controlled by another company, which is referred to as the parent company.

Shares

Units of ownership interest in a corporation or financial asset, representing a portion of the corporation's equity.

Post-Acquisition Equity

The equity interest obtained after the acquisition of assets or another company.

Multiple Subsidiary

Refers to scenarios where a parent company owns more than one subsidiary, each operating as a separate entity but controlled by the parent.