Computer Sciences > Gate 2015 Set-1 > SQL
Select operation in SQL is equivalent to
A
the selection operation in relational algebra
B
the selection operation in relational algebra, except that select in SQL retains duplicates
C
the projection operation in relational algebra
D
the projection operation in relational algebra, except that select in SQL retains duplicates

Correct : SQL

Similar Questions

Consider the following relations: Consider the following SQL query. SELECT S.Student_Name, sum(P.Marks) FROM Student S, Performance P WHERE S.Roll_No = P...
#1149 NAT
Given the following schema: employees(emp-id, first-name, last-name, hire-date, dept-id, salary) departments(dept-id, dept-name, manager-id, location-id) You...
#1225 MCQ
SQL allows duplicate tuples in relations, and correspondingly defines the multiplicity of tuples in the result of joins. Which one of the following queries alwa...
#1251 MCQ

Related Topics

No tags found

Unique Visitor Count

Total Unique Visitors

Loading......