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
Nov 14GATE & PSU CS