​Structure of the ORDERITEMS Table

question 63

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 disable the constraint?​

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

---

Definitions:

Social Loafing

The phenomenon of individuals making less effort to achieve a goal when they work in a group than when they work alone.

Conformity

The act of matching attitudes, beliefs, and behaviors to group norms, politics, or being consistent with the accepted standards in a society.

Cognitive Dissonance

A psychological discomfort experienced when holding two or more conflicting beliefs, values, or attitudes.

Informational Social Influence

The influence to conform with a group's behavior based on the belief that the group is competent and has the correct information.