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

Control Account

An account used in the general ledger to summarize the balances of subsidiary accounts and facilitate the verification of financial information accuracy.

Customer Account Balances

The amounts owed to a company by its customers for goods or services delivered on credit.

Adjusting Entries

Entries made in the accounting records to realign the balances of accounts before financial statements are prepared.

Accrued Expense

An expense that has been incurred but not yet paid, recognized on the financial statements.