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

1 Answer

+18 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 May 2017
  1. akash.dinkar12

    3548 Points

  2. pawan kumarln

    2126 Points

  3. Bikram

    1922 Points

  4. sh!va

    1682 Points

  5. Arjun

    1622 Points

  6. Devshree Dubey

    1272 Points

  7. Debashish Deka

    1270 Points

  8. Angkit

    1056 Points

  9. LeenSharma

    1028 Points

  10. Arnab Bhadra

    812 Points

Monthly Topper: Rs. 500 gift card
Top Users 2017 May 22 - 28
  1. Bikram

    1008 Points

  2. pawan kumarln

    752 Points

  3. Arnab Bhadra

    726 Points

  4. akash.dinkar12

    428 Points

  5. Arjun

    350 Points


22,896 questions
29,206 answers
65,329 comments
27,708 users