Question: . Relation R(a,b) has no duplicate tuples, although neither a nor b is a key. Relation S(c,d) may have duplicates. Which of the following queries
| . | Relation R(a,b) has no duplicate tuples, although neither a nor b is a key. Relation S(c,d) may have duplicates. Which of the following queries is guaranteed to produce no duplicates? |
| a) | SELECT b FROM R WHERE a IN (SELECT d FROM S) | ||
| b) | SELECT c, d FROM S WHERE EXISTS (SELECT a, b FROM R WHERE a = c AND b = d) | ||
| c) | SELECT c, d FROM S GROUP BY c, d | ||
| d) | SELECT b FROM R |
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
