Contents of the PUBLISHER table

-Which of the following commands will delete only publisher 4 from the PUBLISHER table?
A) DELETE FROM publisher;
B) DELETE pubid = 4 FROM publisher;
C) DROP FROM publisher WHERE pubid = 4;
D) DELETE FROM publisher WHERE pubid = 4;

Question

Contents of the PUBLISHER table​
 
-Which of the following commands will delete only publisher 4 from the PUBLISHER table?
A) ​DELETE FROM publisher; 
B) ​DELETE pubid = 4 FROM publisher; 
C) ​DROP FROM publisher WHERE pubid = 4; 
D) ​DELETE FROM publisher WHERE pubid = 4;

Quizplus · Accepted Answer

Option D is the correct command to delete only the publisher with pubid 4 from the PUBLISHER table. Option A would delete all records in the table, while option B is not a valid syntax for the DELETE command. Option C is also an invalid syntax and DROP is used to remove a whole table from the database, not individual records.

Contents of the PUBLISHER Table​

Contents of the PUBLISHER Table