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) none of the above
C) SELECT contact name FROM publisher;
D) SELECT contact person,name FROM publisher;

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) ​none of the above 
C) ​SELECT contact name FROM publisher; 
D) ​SELECT contact person,name FROM publisher;

Quizplus · Accepted Answer

SELECT contact person,name FROM publisher; will display only two columns (contact person and name) as requested in the question. Option A displays all columns, Option B displays none, and Option C only displays one column.

Contents of the PUBLISHER Table