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 name,phone FROM publisher
B) SELECT * FROM publisher;
C) SELECT name,contact 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 name,phone ​FROM publisher 
B) SELECT * FROM publisher;​ 
C) ​SELECT name,contact FROM publisher/ 
D) ​SELECT * FROM publisher;

Quizplus · Accepted Answer

The table contents suggest that there are only two columns in the table - "TB1929_00_TB1929_00_TB1929_00_TB1929_00_TB1929_00_TB1929_00" and "11eab478_fb95_446f_acdb_23697514ed5f". Therefore, option C, which tries to select columns "name" and "contact" that are not present in the table, is not a valid SQL statement. The remaining options are valid, as they either select all columns using "*" or select specific columns - "name" and "phone" - that are present in the table.

Contents of the PUBLISHER Table