​Structure of the PROMOTION Table

question 16

Multiple Choice

​Structure of the PROMOTION table

-Which of the following commands will add a UNIQUE constraint to the MINRETAIL column of the PROMOTION table?​

• A) ALTER TABLE promotion ADD CONSTRAINT orderitems_minretail_uk UNIQUE (minretail);
• B) ALTER TABLE promotion MODIFY UNIQUE (minretail);
• C) ALTER TABLE promotion ADD UNIQUE minretail;
• D) ​ALTER TABLE promotion MODIFY minretail;

---

Definitions:

Principled Leadership

A leadership style that operates on ethical standards and strong principles, often leading by example and fostering trust and respect.

Affective

Relating to moods, feelings, and attitudes; emotional rather than cognitive.

Coordinational

Relates to the effort or ability to organize and align different elements or activities towards achieving a common goal.

Zaccaro

Refers to Stephen J. Zaccaro, a researcher known for his contributions to the field of leadership, focusing on leader effectiveness and the development of leadership skills.