​Structure of the ORDERITEMS Table

question 63

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 disable the constraint?​

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

---

Definitions:

Business

An organization or entrepreneurial entity engaged in commercial, industrial, or professional activities with the aim of generating profits by providing goods or services.

Sweat Equity

The non-monetary investment, typically in the form of labor or services, that a person contributes to a project or business.

Restaurant

A place where prepared food and drinks are sold to the public for consumption on the premises or takeout.

Cousin

A relative with whom a person shares one or more common ancestors, but typically someone outside of a person's immediate family.