Given relations r(w, x) and s(y, z), the result of the query SELECT DISTINCT…

PYQ GATE 2000 CS

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:

  1. A.

    r has no duplicates and s is non-empty

  2. B.

    r and s have no duplicates

  3. C.

    s has no duplicates and r is non-empty

  4. D.

    r and s have the same number of tuples

Attempted by 720 students.

Sign up free to check your answer

Sign up free

Explore the full course: Btsc Lab Assistant

Loading lesson…