Correct answer: (D) the projection operation in relational algebra, except that SELECT in SQL retains duplicates
Explanation
The SELECT clause chooses columns, which is projection in relational algebra. Unlike relational algebra, SQL does not remove duplicate rows unless DISTINCT is used.
More Relational Model: Relational Algebra, Tuple Calculus, SQL questions
GATE 2015 CS (CS1) Q61– Consider the following relations: Student Roll No Student Name --- --- 1 Raj 2 Rohit 3 Raj…
GATE 2017 CS (CS1) Q33– Consider a database that has the relation schema EMP (EmpId, EmpName, and DeptName). An…
GATE 2017 CS (CS1) Q51– Consider a database that has the relation schemas EMP(EmpId, EmpName, DeptId), and…
GATE 2017 CS (CS1) Q56– Consider a database that has the relation schema CR(StudentName, CourseName). An instance…