GATE Papers >> CSE >> 2015 >> Question No 31

Question No. 31 CSE | GATE 2015

SELECT operation in SQL is equivalent to

Answer : (D) the projection operation in relational algebra, except that SELECT in SQL retains duplicates

Solution of Question No 31 of GATE 2015 CSE Paper

$\prod$ in relation algebra is similar to SELECT in SQL but the only difference is that '$\prod$' gives distinct rows by eliminating duplicates but SELECT does not remove duplicates.

No Comments
Leave a comment