Time Left - 10:00 mins
GATE 2020 : Database Quiz 5 (App update required to attempt this test)
Attempt now to get your rank among 688 students!
Question 1
Consider the relation 
and 
having tuples 200, 300 and 100 respectively. Estimate number of tuples in relation 
and having tuples 200, 300 and 100 respectively. Estimate number of tuples in relation Question 2
Consider two relations R1 and R2 given below:
How many tuples are there in relation(Natural join) R1
R2?
How many tuples are there in relation(Natural join) R1
R2?Question 3
Consider the following relations P(X,Y,Z), Q(X,Y,T) and R(Y,V).
How many tuples will be returned by the following relational algebra query?
Question 4
Assume R(A, B) and S(C, D) relations have the following instances.
Find the number of tuples returned by the following query?
[ρ is used to rename]
Find the number of tuples returned by the following query?
[ρ is used to rename]
Question 5
Assume 
and 
relations have the following instances
Find number of tuples returned by the following query (ρ is used to rename the attribute)
and relations have the following instances Find number of tuples returned by the following query (ρ is used to rename the attribute)
Question 6
Relation supplier (Sid, Sname, Saddress) has 100 tuples and relation catalog(Sid, Pid, P name) has 50 tuples. Find the maximum and minimum tuples that can br present in (supplier 
catalog).
(Assume no foreign key present in the relations).
catalog). (Assume no foreign key present in the relations).
- 688 attempts
- 3 upvotes
- 4 comments
Tags :
GATE & PSU CSDatabasesMay 28GATE & PSU CS
