Question 8177 – SQL

SELECT operation in SQL is equivalent to

Correct Answer: D

Question 35 Explanation:

SELECT operation in SQL perform vertical partitioning which is performed by projection operation in relational calculus but SQL is multi sets; hence (D).

the selection operation in relational algebra

the selection operation in relational algebra, except that SELECT in SQL retains duplicates

the projection operation in relational algebra

the projection operation in relational algebra, except that SELECT in SQL retains duplicates