Test Index

GATE Computer Science (CS) 2012 Solved Paper

Show Para Hide Para

Question Numbers: 60-61
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

© examsnet.com

Question : 60

Total: 65

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

7
4
5
9

Go to Question:

Prev Question

Next Question

More Free Exams: