Given relations R(w, x) and S(y, z), the result of
SELECT DISTINCT w,x
FROM R, S
Is guaranteed to be same as R, if
SELECT DISTINCT w,x
FROM R, S
Is guaranteed to be same as R, if
- a)R has no duplicates and S is non-empty
- b)R and S have no duplicates
- c)S has no duplicates and R is non-empty
- d)R and S have the same number of tuples
Correct answer is option 'A'. Can you explain this answer?
Related Test
Answers
|
ANJALI PRADEEP
Jun 13, 2020 |
|
The given query
SELECT DISTINCT W, X
FROM R, S
Is guaranteed to be same as R, if R has no duplicates and ‘S’ is non-empty.
Since, if R is having a duplicates, then the tuples selected by SELECT operation of the R and the given query will not be same also if ‘S’ is empty then the given query outputs null.
SELECT DISTINCT W, X
FROM R, S
Is guaranteed to be same as R, if R has no duplicates and ‘S’ is non-empty.
Since, if R is having a duplicates, then the tuples selected by SELECT operation of the R and the given query will not be same also if ‘S’ is empty then the given query outputs null.
The given querySELECT DISTINCT W, XFROM R, SIs guaranteed to be same as R, if R has no duplicates and ‘S’ is non-empty.Since, if R is having a duplicates, then the tuples selected by SELECT operation of the R and the given query will not be same also if ‘S’ is empty then the given query outputs null.
Top Courses for Computer Science Engineering (CSE)
Related Content
 |
|
 |
 |
|
 |
|
 |
|
Download free EduRev App
Track your progress, build streaks, highlight & save important lessons and more!
The given querySELECT DISTINCT W, XFROM R, SIs guaranteed to be same as R, if R has no duplicates and ‘S’ is non-empty.Since, if R is having a duplicates, then the tuples selected by SELECT operation of the R and the given query will not be same also if ‘S’ is empty then the given query outputs null.
|
© EduRev
|
Follow Us
|
