Time Left - 15:00 mins

GATE CS 2022: Database -2

Attempt now to get your rank among 252 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. RS

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 references to primary key or alternative key of same relation or some other relation. Select the correct option regarding the foreign key. [Multiple Select Question]

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?

  • 252 attempts
  • 0 upvotes
  • 0 comments
May 26GATE & PSU CS

Posted by:

Priya UpadhyayPriya UpadhyayMember since Sep 2020
Priya Upadhyay
Share this quiz   |