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

Gold Reserves

The amount of gold held by a central bank or government to support the value of its currency and to settle debts or engage in trade.

Create Money

The process by which the central bank or financial institutions increase the money supply in the economy, typically through activities such as lending or purchasing government securities.

Demand Deposits

Bank account balances that can be withdrawn on demand with no prior notice, such as checking accounts, providing liquidity and flexibility for accountholders.

Inflation

The rate of growth in the average cost of goods and services, which lowers the purchasing capacity.