![GATE 2015 [Set-1]](https://solutionsadda.in/wp-content/uploads/2019/05/green-new-logo.png){kind=logo}
Database-Management-System
March 4, 2024Database-Management-System
March 4, 2024GATE 2015 [Set-1]
|
Question 20
|
SELECT operation in SQL is equivalent to
|
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
|
Question 20 Explanation:
SELECT operation in SQL perform vertical partitioning which is performed by projection operation in relational calculus but SQL is multi sets; hence (D).
Correct Answer: D
Question 20 Explanation:
SELECT operation in SQL perform vertical partitioning which is performed by projection operation in relational calculus but SQL is multi sets; hence (D).