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

Question

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

Quizplus · Accepted Answer

Option A is the correct syntax to create a table in SQL. It starts with the CREATE TABLE command followed by the table name and the column names with their respective data types. Option B is incorrect because "AS" is used to create a table using a subquery, not for defining columns. Option C is incorrect because "ADD" is used to add columns to an existing table, not to create a new table. Option D is incorrect because it is missing the closing parenthesis at the end of the column definitions.

Structure of the PROMOTION Table​

Structure of the PROMOTION Table