Time Left - 15:00 mins
GATE CS 2022: Database -2
Attempt now to get your rank among 294 students!
Question 1
Which of the following statement is false?
Question 2
Suppose relation R(ABC) has the tuples:
How many tuples resulted by given Relational Algebra expression?
πA,B(R)⋈R.B<S.BρS(A,B) (πB.C(R))
Question 3
Consider relation ‘R’ and ‘S’ have ‘n’ and ‘m’ tuples, respectively. Choose the best matching between List-I (Expression) and List-II (Maximum number of tuple):
List-I
P. R∪S
Q. R ⋈ S
R. σC(R) × S
S. πL(R) – S
List-II
1) n
2) m × n
3) Min (m, n)
4) N + m
Question 4Multiple Correct Options
Foreign key is a set of attributes that references to primary key or alternative key of same relation or some other relation. Select the correct option regarding the foreign key.
Question 5
Consider the following schedule S of transactions T1, T2, T3 and T4:
Which one of the following statement/s is correct?
Question 6
Consider the Two sets of FD’s for the relation R(ABCDE):
F1 = {A → B,AB → C, D → AC, D → E}
F2 = {A → BC, D → AE}
Which of the following statement true about FD set?
- 294 attempts
- 0 upvotes
- 0 comments
Tags :
GATE & PSU CSDatabasesNov 14GATE & PSU CS