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

PYQ GATE 2012

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 332 students.

Sign up free to check your answer

Sign up free

Explore the full course: Zero To Hero

Loading lesson…