Contents of the PUBLISHER table

-Based upon the contents of the PUBLISHER table,which of the following SQL statements will execute without returning an error message?
A) SELECT pubid PUBLISHERID name FROM publisher;
B) SELECT pubid "PUBLISHER ID" name FROM publisher;
C) SELECT pubid name FROM publisher;
D) all of the above

Question

Contents of the PUBLISHER table
  ​
-Based upon the contents of the PUBLISHER table,which of the following SQL statements will execute without returning an error message?​
A) ​SELECT pubid PUBLISHERID name FROM publisher; 
B) ​SELECT pubid "PUBLISHER ID" name FROM publisher; 
C) ​SELECT pubid name FROM publisher; 
D) ​all of the above

Quizplus · Accepted Answer

The SQL statement in option C is correctly formatted with a comma separating the column names.

Contents of the PUBLISHER Table