GATE Computer Science (CS) 2012 Solved Paper
Show Para
Question Numbers: 60-61
Consider the following relations A, B and C:
Consider the following relations A, B and C:
|
A |
||
|
Id |
Name |
Age |
|
12 |
Arun |
60 |
|
15 |
Shreya |
24 |
|
99 |
Rohit |
11 |
|
B |
||
|
Id |
Name |
Age |
|
15 |
Shreya |
24 |
|
25 |
Hari |
40 |
|
98 |
Rohit |
20 |
|
99 |
Rohit |
11 |
|
C |
||
|
Id |
Phone |
Area |
|
10 |
2200 |
02 |
|
99 |
2100 |
01 |
© examsiri.com
Question : 60 of 65
Marks:
+1,
-0
How many tuples does the result of the following relational algebra expression contain? Assume that the schema of A∪B is the same as that of A.
(A∪B) ⋈ A.Id > 40 ∨ C.Id < 15 C
(A∪B) ⋈ A.Id > 40 ∨ C.Id < 15 C
Go to Question: