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

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

Quizplus · Accepted Answer

The PUBLISHER table contains information about publishers, including their ID, name, and contact information. Therefore, the correct SQL statement would be to select all columns (represented by the wildcard *) from the PUBLISHER table using: SELECT * FROM publisher. Choices A, B, and C are incorrect because they do not reference the correct table or column names.

Contents of the PUBLISHER Table