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

1 Answer

+16 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 Feb 2017
  1. Arjun

    5288 Points

  2. Bikram

    4230 Points

  3. Habibkhan

    3952 Points

  4. Aboveallplayer

    3086 Points

  5. Debashish Deka

    2378 Points

  6. sriv_shubham

    2308 Points

  7. Smriti012

    2236 Points

  8. Arnabi

    2008 Points

  9. mcjoshi

    1690 Points

  10. sh!va

    1684 Points

Monthly Topper: Rs. 500 gift card

20,860 questions
26,012 answers
59,674 comments
22,114 users