Contents of the PUBLISHER table

-Based upon the contents of the PUBLISHER table, which of the following SQL statements will display only two columns in the results?
A) SELECT * FROM publisher;
B) SELECT contact name FROM publisher;
C) SELECT contact person, name FROM publisher;
D) none of the above

Question

Contents of the PUBLISHER table
 
-Based upon the contents of the PUBLISHER table, which of the following SQL statements will display only two columns in the results?
A) SELECT * FROM publisher; 
B) SELECT contact name FROM publisher; 
C) SELECT contact person, name FROM publisher; 
D) none of the above

Quizplus · Accepted Answer

Option A will display all columns from the publisher table, which is not required as we only need to display two columns. Option B will only display the contact name column, leaving out the name column which is required. Option C will display both the contact person and name columns, which meets the requirement. Option D is incorrect as option C is the right choice.

Contents of the PUBLISHER Table