Contents of the BOOKS table

-Based upon the contents of the BOOKS table, which of the following is a valid SQL statement?
A) select pubid, isbn, from books;
B) select * FROM pubid;
C) select pubid, "Publisher ID" from books;
D) none of the above

Question

Contents of the BOOKS table
 
-Based upon the contents of the BOOKS table, which of the following is a valid SQL statement?
A) select pubid, isbn, from books; 
B) select * FROM pubid; 
C) select pubid, "Publisher ID" from books; 
D) none of the above

Quizplus · Accepted Answer

Explanation: Option A has a syntax error due to an extra comma. Option B is incorrect because it attempts to select from a column instead of a table. Option C is incorrect because it uses double quotes for an alias, which is not standard SQL syntax.

Contents of the BOOKS Table