Contents of the PROMOTION table

-Which of the following SQL statements will insert a new row into the PROMOTION table?
A) INSERT INTO promotion (gift,minretail,maxretail) VALUES (FREE BOOK,75.01,89.99);
B) INSERT INTO promotion (gift,minretail,maxretail) VALUES ('FREE BOOK',75.01,89.99);
C) INSERT INTO promotion VALUES (FREE BOOK,75.01,89.99);
D) both a and c

Question

Contents of the PROMOTION table​
  ​
-Which of the following SQL statements will insert a new row into the PROMOTION table?​
A) ​INSERT INTO promotion (gift,minretail,maxretail) VALUES (FREE BOOK,75.01,89.99); 
B) ​INSERT INTO promotion (gift,minretail,maxretail) VALUES ('FREE BOOK',75.01,89.99); 
C) ​INSERT INTO promotion VALUES (FREE BOOK,75.01,89.99); 
D) ​both a and c

Quizplus · Accepted Answer

Option B is the correct SQL statement to insert a new row into the PROMOTION table as it uses single quotes to enclose the value for the gift column, which is a string data type. Option A is incorrect as it does not enclose the string value in single quotes. Option C is incorrect as it does not specify the column names and their corresponding values to be inserted. Option D is also incorrect as option A is not a valid SQL statement.

Contents of the PROMOTION Table​

Contents of the PROMOTION Table