Computer Sciences > GATE 2014 SET-2 > SQL
SQL allows duplicate tuples in relations, and correspondingly defines the multiplicity of tuples in the result of joins. Which one of the following queries always gives the same answer as the nested query shown below:
SELECT * FROM R WHERE a IN (SELECT S.a FROM S)
A
SELECT R.* FROM R, S WHERE R.a = S.a
B
SELECT DISTINCT R.* FROM R, S WHERE R.a = S.a
C
SELECT R.* FROM R, (SELECT DISTINCT a FROM S) AS S1 WHERE R.a = S1.a
D
SELECT R.* FROM R, S WHERE R.a = S.a AND a IS UNIQUE R

Correct : c

Similar Questions

Select operation in SQL is equivalent to
#79 MCQ
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

Related Topics

SQL queries nested queries SQL IN clause duplicate tuples SQL SQL joins GATE CS 2014 Set-2 Q31 Database Management Systems SQL query equivalence

Unique Visitor Count

Total Unique Visitors

Loading......

Question Options

Contributed by: