GATE CSE
First time here? Checkout the FAQ!
x
+11 votes
1.1k views

SELECT operation in SQL is equivalent to

  1. The selection operation in relational algebra
  2. The selection operation in relational algebra, except that SELECT in SQL retains duplicates
  3. The projection operation in relational algebra
  4. The projection operation in relational algebra, except that SELECT in SQL retains duplicates
asked in Databases by Veteran (30.4k points)   | 1.1k views

1 Answer

+20 votes
Best answer

option D is correct because SELECT operation in SQL is equivalent to The projection operation in relational algebra, except that SELECT in SQL retains duplicates but projection gives only distinct  

answered by Loyal (4.8k points)  
selected by
@Arjun Sir: This question is an perfect example where GATE gets really tricky. Most will write Option B.

Now such questions really clear the concepts. This should be marked as tricky. I'd ask you to add one more tag apart from easy normal hard a TRICKY tag. there are tons of such tricky questions. Pondering over these would help a lot of Gate Aspirants.
Actually I wouldn't mark this as tricky as GATE has more trickier questions in store :)

But, whichever question you find like this, you can mark as "favorite" and this can be useful during exam time for quick reference.
any source/material for explanation!


Top Users Jul 2017
  1. Bikram

    5368 Points

  2. manu00x

    3092 Points

  3. Arjun

    1924 Points

  4. joshi_nitish

    1898 Points

  5. Debashish Deka

    1874 Points

  6. pawan kumarln

    1454 Points

  7. Tesla!

    1390 Points

  8. Hemant Parihar

    1314 Points

  9. Shubhanshu

    1136 Points

  10. Arnab Bhadra

    1124 Points


24,141 questions
31,143 answers
70,892 comments
29,467 users