Contents of the PROMOTION table

-Based on the contents of the PROMOTION table,which of the following commands will delete only the row for the Free Bookmark from the table?
A) DELETE FROM promotion;
B) DELETE gift FROM promotion;
C) DELETE gift FROM promotion WHERE gift = 'BOOKMARKER';
D) DELETE FROM promotion WHERE gift = 'BOOKMARKER';

Question

Contents of the PROMOTION table​
  ​
-Based on the contents of the PROMOTION table,which of the following commands will delete only the row for the Free Bookmark from the table?​
A) ​DELETE FROM promotion; 
B) ​DELETE gift FROM promotion; 
C) ​DELETE gift FROM promotion WHERE gift = 'BOOKMARKER'; 
D) ​DELETE FROM promotion WHERE gift = 'BOOKMARKER';

Quizplus · Accepted Answer

Option D is the correct choice because it specifies to delete only the row that has a gift value of 'BOOKMARKER'. Option A would delete all rows in the table, Option B is syntactically incorrect, and Option C specifies the wrong gift value to delete.

Contents of the PROMOTION Table​

Contents of the PROMOTION Table