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 WHERE Promotion_Name='Free Bookmark';
b) REMOVE PROMOTION WHERE Name='Free Bookmark';
c) DROP PROMOTION IF Name='Free Bookmark';
d) ERASE FROM PROMOTION WHERE Promotion_Name='Free Bookmark

Answer 1

The correct command to delete the row for the Free Bookmark from the PROMOTION table is: DELETE FROM PROMOTION WHERE Promotion_Name='Free Bookmark'; as it's syntactically correct and targets the desired row.

Step-by-step explanation:

Based on the contents of the PROMOTION table, to delete only the row for the Free Bookmark from the table, the correct SQL command to use is option a): DELETE FROM PROMOTION WHERE Promotion_Name='Free Bookmark';.

This command will search the PROMOTION table for a row where the column Promotion_Name matches the value 'Free Bookmark' and will delete that specific row. The other options provided are syntactically incorrect or are not valid SQL commands for deleting rows.