UTpaper

Free mock tests & test series

Question 139Asked in CIL MT Systems, 26 Mar 2017 (12:30 PM)

Consider the following relation schema R and S along with their tuple sets.

Consider the following relation schema R and S along with their tuple sets. R(A, B) = {<a1, b1>, <a2, b1>, <a3, b1>, <a4, b1>, <a1, b2>, <a3, b2>, <a2, b3>, <a3, b3>, <a4, b3>, <a1, b4>, <a2, b4>, <a3, b4>} S(A) = {a1, a2, a3} What is the value of T ← R / S, where "/" represents the Relational Algebra "division" operation?
  1. AT(B) = {b1, b3}
  2. BT(B) = {b1, b2, b4}
  3. CT(B) = {b1, b4}
  4. DT(B) = {b1, b3, b4}
Show answerHide answer

Correct answer: (C) T(B) = {b1, b4}

From CIL MT Systems PYQ, 26 Mar 2017 (12:30 PM)

This is question 139 of CIL MT Systems PYQ, 26 Mar 2017 (12:30 PM). See all questions of this paper with answers, or attempt the paper as a timed online test to get your score and all-India rank.