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

Downward Sloping

A term often used to describe a graph line indicating a decrease in one variable as another variable increases, such as price and demand.

Indifference Curves

Graphical representations that show combinations of two goods between which a consumer is indifferent.

Perfect Substitutes

Goods or services that can be used in exactly the same way and are interchangeable in consumption without affecting consumer satisfaction.

Straight Lines

Typically refers to the simplest form used in geometry and graphical analysis, representing a direct and continuous path between two points without any curves.