Contents of the PUBLISHER table

-Based on the contents of the PUBLISHER table,which of the following will add a new record to the table?
A) INSERT INTO publisher VALUES ('BOOKS MADE CHEAP','800-111-2222');
B) INSERT INTO publisher (pubid,name) VALUES (6,'BOOKS MADE CHEAP');
C) UPDATE publisher VALUES ('BOOKS MADE CHEAP','800-111-2222');
D) UPDATE publisher (pubid,name) VALUES (6,'BOOKS MADE CHEAP');

Question

Contents of the PUBLISHER table​
 
-Based on the contents of the PUBLISHER table,which of the following will add a new record to the table?
A) ​INSERT INTO publisher VALUES ('BOOKS MADE CHEAP','800-111-2222'); 
B) ​INSERT INTO publisher (pubid,name) VALUES (6,'BOOKS MADE CHEAP'); 
C) ​UPDATE publisher VALUES ('BOOKS MADE CHEAP','800-111-2222'); 
D) ​UPDATE publisher (pubid,name) VALUES (6,'BOOKS MADE CHEAP');

Quizplus · Accepted Answer

The contents of the PUBLISHER table suggest that it has at least two columns: pubid and name. Option A attempts to insert only one value, which is not allowed since there are two columns in the table. Option C is incorrect because it is attempting to update existing records in the table rather than adding a new one. Option D is also incorrect because there is no existing record to update with the given pubid. Option B is the correct choice because it specifies the pubid and name values to insert into the table, adding a new record.

Contents of the PUBLISHER Table​

Contents of the PUBLISHER Table