GATEverse
← GATE CSE 2012

Q50

MCQ2 marks, −0.67

Consider the following relations A,BA, B and C:C:

IDNameAge12Arun6015Shreya2499Rohit11AIDNameAge15Shreya2425Hari4098Rohit2099Rohit11BIDPhoneArea1022000299210001C\overset{\text{A}}{\begin{array}{|c|c|c|} \hline \text {ID} & \text {Name} & \text {Age} \\\hline\text{12}& \text{Arun} & \text{60} \\\hline\text{15}& \text{Shreya} & \text{24} \\\hline\text{99}& \text{Rohit} & \text{11} \\\hline \end{array}} \qquad \overset{\text{B}}{\begin{array}{|c|c|c|} \hline \text {ID} & \text {Name} & \text {Age} \\\hline \text{15}& \text{Shreya} & \text{24} \\\hline\text{25}& \text{Hari} & \text{40} \\\hline\text{98}& \text{Rohit} & \text{20} \\\hline\text{99}& \text{Rohit} & \text{11} \\\hline \end{array}}\qquad \overset{\text{C}}{\begin{array}{|c|c|c|} \hline \text {ID} & \text {Phone} & \text {Area} \\\hline \text{10}& \text{2200} & \text{02} \\\hline\text{99}& \text{2100} & \text{01} \\\hline \end{array}}

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
Sign in to save attempts.

Loading…