​Structure of the ORDERITEMS Table

question 11

Multiple Choice

​Structure of the ORDERITEMS table

-If a PRIMARY KEY constraint,named ORDERITEMS_PK,for the ORDER# and ITEM# columns of the ORDERITEMS table have been disabled,which of the following commands will enable the constraint?​

• A) ALTER TABLE orderitems ENABLE PRIMARY KEY CONSTRAINT;
• B) ALTER TABLE orderitems ENABLE CONSTRAINT orderitems_pk;
• C) ALTER TABLE orderitems MODIFY PRIMARY KEY CONSTRAINT;
• D) ​ALTER TABLE orderitems MODIFY PRIMARY KEY CONSTRAINT ENABLE;

---

Definitions:

Directed Verdict

A directed verdict is a ruling entered by a trial judge after determining that no reasonable jury could reach a decision to the contrary.

Dodd-Frank Wall Street Reform

Comprehensive legislation passed in 2010 aimed at reducing risks in the U.S. financial system through increased regulation.

Consumer Protection Act

Legislation aimed at protecting consumers from unfair, deceptive, or fraudulent practices in the marketplace, ensuring their rights are safeguarded.

Arbitration

A form of alternative dispute resolution where a neutral third party, the arbitrator, makes a decision to resolve a dispute outside of court.