aliensbrain
  • Home
  • Study
  • Quizzes
  • 🎤AI Practicefree
  • Notebooks
  • Community
  • Sign in
  • DBMS Practice Test: Normalization and Transactions
  • The total number of function dependencies (both trivial a...
Multiple choice

The total number of function dependencies (both trivial and non trivial) that can be formed over relation having degree = n are

  1. $2^n$
  2. $2^{2n}$
  3. $n!$
  4. $2+n!$
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

If R(A, B) ie n = 2

$\left \{ A, B \\ AB, \phi \right\} \rightarrow \left \{ A, b \\ AB, \phi \right\}$ $2^n \times 2^n = 2^{2n}$

Keep practicing — related questions

  • The following functional dependencies hold for relations R(A, B, C) and S(B, D, E) B $\rightarrow$A, A $\ri...
  • The total number of Boolean functions that can be generated by n variables is equal to
  • 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...
  • Which of the following functions is not directly related to a file?
  • Which of the following SQL functions returns the number of values from the specified column with no NULL va...
  • What is the full form of term KERMA related to nuclear medicine?
  • Stripes of a tiger is an example of _________. Two closely related insect species are there. One is reddish...
  • Mr Ravi had invested Rs. 52,000 in 18% Rs. 200 shares at a premium of 30%. What is the total number of shar...
Play the full quiz 🎤 Practise this topic out loud
Advertisement
© Aliensbrain | all rights reserved
  • About
  • Contact
  • Terms and Condition
  • Privacy Policy