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

Considering the relation schemas R (A, B, C, D) and S (C, D, E, F), what will be the degree of the resultant relation of the following Relational Algebra…

Considering the relation schemas R (A, B, C, D) and S (C, D, E, F), what will be the degree of the resultant relation of the following Relational Algebra expression, where "*" represents the "natural join" operation? (σc1(ΠA,B,C(R))) * (σc2(ΠC,D,E(S)))
  1. A3
  2. B4
  3. C6
  4. D5
Show answerHide answer

Correct answer: (D) 5

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

This is question 104 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.