Transactions
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
| Question 526 |
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
| R has no duplicates and S is non-empty | |
| R and S have no duplicates | |
| S has no duplicates and R is non-empty | |
| R and S have the same number of tuples |
Correct Answer: A