Contents of the PUBLISHER table

-Based upon the contents of the PUBLISHER table, which of the following is a valid SQL statement?
A) SELECT contact Contact's Name FROM publisher;
B) SELECT contact, name FROM publisher;
C) SELECT publisherID FROM publisher;
D) SELECT name FROM publishers;

Question

Contents of the PUBLISHER table
 
-Based upon the contents of the PUBLISHER table, which of the following is a valid SQL statement?
A) SELECT contact Contact's Name FROM publisher; 
B) SELECT contact, name FROM publisher; 
C) SELECT publisherID FROM publisher; 
D) SELECT name FROM publishers;

Quizplus · Accepted Answer

The PUBLISHER table contains columns named "contact" and "name," so Option B correctly selects both of those columns from the table.

Answer: D
 There is no column named "publisherID" in the PUBLISHER table, so Option C is not a valid SQL statement. Option D misses an "s" in "publishers" - it should be "publisher" - therefore, it is also not a valid SQL statement.

Contents of the PUBLISHER Table