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 name FROM publisher;
C) SELECT pubid "PUBLISHER ID" 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 name FROM publisher; 
C) SELECT pubid "PUBLISHER ID" name FROM publisher; 
D) all of the above

Quizplus · Accepted Answer

The Answer of 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 name FROM publisher; 
C) SELECT pubid "PUBLISHER ID" name FROM publisher; 
D) all of the above

Contents of the PUBLISHER Table