Structure of the PROMOTION Table​

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) ;