Contents of the PUBLISHER table

-Based upon the contents of the PUBLISHER table, which of the following is not a valid SQL statement?
A) SELECT * FROM publisher;
B) SELECT name, contact FROM publisher/
C) SELECT name, phone FROM publisher /
D) SELECT * FROM publisher;

Question

Contents of the PUBLISHER table
 
-Based upon the contents of the PUBLISHER table, which of the following is not a valid SQL statement?
A) SELECT * FROM publisher; 
B) SELECT name, contact FROM publisher/ 
C) SELECT name, phone FROM publisher / 
D) SELECT * FROM publisher;

Quizplus · Accepted Answer

The forward slash "/" at the end of the SELECT statement in option B is not a valid symbol in SQL, so this statement would result in a syntax error. The rest of the options are valid SQL statements, with option D being the most commonly used to select all columns from a table.

Contents of the PUBLISHER Table