​Structure of the ORDERITEMS Table

question 89

Multiple Choice

​Structure of the ORDERITEMS table

-If the constraints on the ORDER# and ITEM# columns of the ORDERITEMS table were created as a PRIMARY constraint,and the actual constraint name is not known,which of the following commands can be used to delete the constraint?​

• A) ALTER TABLE orderitems DROP ALL CONSTRAINTS;
• B) ALTER TABLE orderitems DELETE ALL CONSTRAINTS;
• C) ALTER TABLE orderitems DROP PRIMARY KEY;
• D) ​ALTER TABLE orderitems DELETE PRIMARY KEY;

---

Definitions:

Facilitated

To facilitate means to make an action or process easier or to assist in the progress of something, often by providing necessary resources, information, or support.

Lafayette's Visit

Refers to the tour of the United States by the Marquis de Lafayette, a French aristocrat and military officer who fought in the American Revolutionary War, celebrated as a hero during his visit in the early 19th century.

Federalists

Members of a political group in the early United States advocating for a strong federal government and the ratification of the Constitution.

Emancipation

The act of being freed from slavery, bondage, or other forms of control or oppression.