In an SQL SELECT command a SELECT clause with several attributes, a FROM clause with multiple tables and a WHERE clause with join fields set equal plus other predicates indicate a(n) ____.
A) relational Select operation
B) relational Project operation
C) combination of relational Select and Project operations
D) combination of relational Select, Project, and Join operations
E) None of the above.

Question

Quizplus · Accepted Answer

The SELECT clause with several attributes indicates a Project operation, the FROM clause with multiple tables indicates a Join operation, and the WHERE clause with join fields set equal and other predicates indicates a Select operation. Therefore, the SQL command is a combination of relational Select, Project, and Join operations.

In an SQL SELECT Command a SELECT Clause with Several