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

Work-Related Diseases

Illnesses contracted as a direct result of an individual's employment, typically through exposure to chemicals, processes, or environments that are hazardous.

State Workers' Compensation Laws

The regulations established by individual states in the United States to provide benefits to employees who are injured or become ill as a direct result of their job.

Accidental

Occurring unexpectedly or by chance, without being planned or intended.

Lie-Detector Tests

Polygraph tests used to measure and record physiological indicators while the subject is asked a series of questions, aiming to detect truthfulness.