aliensbrain
  • Home
  • Study
  • Quizzes
  • 🎤AI Practicefree
  • Notebooks
  • Community
  • Sign in
  • Computer Science (GATE Exam) 2010 - Previous Question Paper Solution
  • The following functional dependencies hold for relations ...
Multiple choice

The following functional dependencies hold for relations R(A, B, C) and S(B, D, E) B $\rightarrow$A, A $\rightarrow$C The relation R contains 200tuples and the relation S contains 100tuples. What is the maximum number of tuples possible in the natural join $R \bowtie S$

  1. 100

  2. 200

  3. 300

  4. 2000

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Keep practicing — related questions

  • Set F of functional dependencies for relation schema R(A, B, C, D, E) is A$\rightarrow$BC, CD$\rightarrow$E...
  • Consider the following relation schema pertaining to a students database: Student (rollno, name, address) E...
  • Consider the following relation schema pertaining to a students database: Student (rollno, name, address) E...
  • Consider the following relation instance. X Y Z 1 4 2 1 5 3 1 6 3 3 2 2 Which of the following functional d...
  • In the Join of a relation P with a relation Q, P has 'm' tuples and Q has 'n' tuples. Then, the maximum and...
  • Relation R has eight attributes ABCDEFGH. Fields of R contain only atomic values. F = {CH $\leftarrow$ G, A...
  • The total number of function dependencies (both trivial and non trivial) that can be formed over relation h...
  • Consider a relation scheme R = (A,B,C,D,E,H) on which the following functional dependencies hold: {A $\righ...
Play the full quiz 🎤 Practise this topic out loud
Advertisement
© Aliensbrain | all rights reserved
  • About
  • Contact
  • Terms and Condition
  • Privacy Policy