GATE CSE
First time here? Checkout the FAQ!
x
+17 votes
1.2k 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 (38.8k points)   | 1.2k views

1 Answer

+25 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.9k 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 Sep 2017
  1. Habibkhan

    6970 Points

  2. Warrior

    2490 Points

  3. Arjun

    2368 Points

  4. rishu_darkshadow

    2136 Points

  5. A_i_$_h

    2004 Points

  6. nikunj

    1980 Points

  7. makhdoom ghaya

    1760 Points

  8. manu00x

    1750 Points

  9. Bikram

    1744 Points

  10. SiddharthMahapatra

    1718 Points


26,060 questions
33,668 answers
79,747 comments
31,079 users