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

Positive Net Present Value

A situation where the present value of cash inflows exceeds the present value of cash outflows, indicating a profitable investment.

Book Value Weights

Utilized in calculating weighted average cost of capital (WACC), referring to the proportion of each type of capital (debt, equity) based on its book value.

Market Values

The current prices at which assets, securities, or goods can be bought or sold in a marketplace, reflecting their perceived worth by buyers and sellers.

Cost of Capital

The rate of return that a company must earn on its investment projects to maintain its market value and attract funds, including the cost of debt and the cost of equity.