GATE | GATE-CS-2000 | Question 49
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, provided
Attention reader! Don’t stop learning now. Practice GATE exam well before the actual exam with the subject-wise and overall quizzes available in GATE Test Series Course.
Learn all GATE CS concepts with Free Live Classes on our youtube channel.
(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
Explanation: See question 3 of https://www.geeksforgeeks.org/database-management-system-set-1/
Quiz of this Question