Contents of the PUBLISHER table

-Based upon the contents of the PUBLISHER table,which of the following is a valid SQL statement?
A) SELECT * FROM contact;
B) SELECT * FROM publisher;
C) SELECT * FROM pubid;
D) SELECT * FROM name;

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 * FROM contact; 
B) ​SELECT * FROM publisher; 
C) ​SELECT * FROM pubid; 
D) ​SELECT * FROM name;

Quizplus · Accepted Answer

Since the contents of the table are named "PUBLISHER", the correct SQL statement would be to select all data from the "publisher" table. Choice A, C, and D are not valid as there is no such table with those names mentioned in the prompt.

Contents of the PUBLISHER Table