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