Given relations r(w, x) and s(y, z), the result of the query SELECT DISTINCT…
GATE · 2000 · CS · Question 2 subparts
Given relations r(w, x) and s(y, z), the result of the query
SELECT DISTINCT w, x
FROM r, s;
is guaranteed to be the same as r, provided:
- 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
Attempted by 564 students.
Sign up free to check your answer
Sign up freeLoading lesson…