The Gateway to Computer Science Excellence
+32 votes
2.6k 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
in Databases by Boss (30.8k points)
edited by | 2.6k views

1 Answer

+43 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. 

by Active (5k points)
edited by
+11
@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.
+18
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.
0
any source/material for explanation!
0
0
Selection in relational algebra select rows and projection in RA select columns. Select operation in SQL selects columns but duplicates values are retained in SQL.
Answer:

Related questions

Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true
50,737 questions
57,370 answers
198,506 comments
105,274 users