![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).