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

Professional Sports Players

Individuals who compete in athletic competitions and are paid for their performance and participation in sports.

Revenue Stream

The source of income for a business or organization, which can come from sales, services, investments, or other channels.

Identical Skill Levels

Refers to a situation where individuals or entities have the same level of expertise or competence in a specific domain.

Wage Rate

The fixed amount of compensation or payment received by an employee for employment services, typically expressed per hour or year.