Structure of the PROMOTION Table​

question 122

Multiple Choice

Structure of the PROMOTION table​

-​Which of the following SQL statements was most likely used to create the PROMOTION table?

• A) CREATE TABLE promotion (gift VARCHAR2(15),minretail NUMBER(5,2),maxretail NUMBER(5,2));​
• B) ​CREATE TABLE promotion AS (gift VARCHAR2(15),minretail NUMBER(5,2),maxretail NUMBER(5,2));
• C) ​CREATE TABLE promotion ADD (gift VARCHAR2(15),minretail NUMBER(5,2),maxretail NUMBER(5,2));
• D) ​CREATE TABLE promotion (gift VARCHAR2(15),minretail NUMBER(5,2),maxretail NUMBER(5,2);

---

Definitions:

Sales Discounts

Reductions in the sale price offered by a seller as an incentive for prompt payment by the buyer.

Cash Collection

The process of gathering and processing payments received from customers or clients.

Credit Terms

The conditions under which credit will be extended to a borrower, including repayment schedule, interest rate, and the lifespan of the loan.

Sales Discount

A Sales Discount is a reduction in the price of a product or service offered by a seller, typically to incentivize prompt payment by the buyer.