Contents of the BOOKS table

-Which of the following is a valid SQL statement?
A) SELECT DISTINCT title,category FROM books/
B) all of the above
C) SELECT title,retail-cost FROM books;
D) SELECT title,retail-cost "Profit"

Question

Contents of the BOOKS table
 
-Which of the following is a valid SQL statement?​
A) ​SELECT DISTINCT title,category FROM books/ 
B) ​all of the above 
C) ​SELECT title,retail-cost FROM books; 
D) ​SELECT title,retail-cost "Profit"

Quizplus · Accepted Answer

Since the table only contains a long string of text, it is not possible to extract any actual data such as title or cost. Therefore, option C is the only valid SQL statement as it does not require any actual data from the table. Options A and D both require specific columns to be present in the table, which cannot be determined from the given contents. Option B is incorrect as it includes option A which is not valid.

Contents of the BOOKS Table