Consider the following relations A, B and C: How many tuples does the result…

GATE · 2012 · CS · Computer Science & IT

Consider the following relations A, B and C:

How many tuples does the result of the following relational algebra expression contain? Assume that the schema of A∪BA \cup B is the same as that of AA.

(A∪B)⋈A.Id>40∨C.Id<15C(A\cup B)\bowtie _{A.Id > 40 \vee C.Id < 15} C

  1. A.

    7

  2. B.

    4

  3. C.

    5

  4. D.

    9

Attempted by 282 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…