Q. Suppose now that R(A,B:) and S(A,B:) are two relations with r and s tuples, respectively(again, not necessarily distinct). If m is the number of (not necessarily distinct) tuples in theresult of the SQL query: R intersect S; Then which of the following is the most restrictive, correct condition on the value of m? (Solved)

1. m = min(r,s)

2. 0 <= m <= r + s

3. min(r,s) <= m <= max(r,s)

4. 0 <= m <= min(r,s)

  • d. 0 <= m <= min(r,s)
Subscribe Now

Get All Updates & News