​Structure of the PROMOTION Table

question 53

Multiple Choice

​Structure of the PROMOTION table

-Based on the structure of the PROMOTION table,which of the following commands will add a PRIMARY KEY constraint to the GIFT column?​

• A) CREATE TABLE promotion (gift VARCHAR2(15)PRIMARY KEY, Minretail NUMBER(5,2), Maxretail NUMBER(5,2));
• B) ALTER TABLE promotion ADD PRIMARY KEY(gift);
• C) ​ALTER TABLE promotion MODIFY (gift PRIMARY KE
• Y);
• D) ​none of the above

---

Definitions:

Regulatory Forces

External rules and regulations imposed by governing bodies that affect how businesses operate and interact with customers.

F. Hoffman-LaRoche Ltd.

A global pharmaceutical and diagnostics company that focuses on advancing science to improve people's lives.

BASF AG

A leading global chemical company headquartered in Ludwigshafen, Germany, known for its vast range of products across multiple industries.

Price Fixing

An illegal agreement among competitors to maintain the price of a product or service at a fixed or coordinated level, restricting competition.