Under what conditions does a valid SQL statement not include a WHERE clause?
A) If the query is intended to accomplish only a relational algebra selection operation.
B) If the query is intended to accomplish only a relational algebra project operation.
C) If the query is intended to accomplish only a relational algebra join operation.
D) If the query is intended to combine a relational algebra join with a relational algebra selection operation.
E) No conditions exist under which an SQL statement is valid without including a WHERE clause; i.e., all SQL statements must include a WHERE clause.

Question

Quizplus · Accepted Answer

A SQL statement does not require a WHERE clause if it is intended to perform a projection operation, which involves selecting specific columns from a table without filtering rows.

Under What Conditions Does a Valid SQL Statement Not Include