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

Gross Profit

The difference between sales revenue and the cost of goods sold (COGS), indicating the profit made before deducting operating expenses.

Construction Costs

Expenses related directly to the construction of a building or infrastructure project, including materials, labor, and overhead.

Estimated Costs

Projected expenses related to the manufacturing of a product, execution of a project, or delivery of a service.

Provision for Loss

A Provision for Loss is an amount set aside in the accounts to cover identified but not yet realized losses or expenses.