Functional Dependencies MCQs Quiz Online Tests pdf Download

Practice functional dependencies MCQs, DBMS (MCQ) for online test prep. Functional dependencies and normalization quiz has multiple choice questions (MCQ), functional dependencies quiz question and answers as rule which states that addition of same attributes to right side and left side will results in other valid dependency is classified as, answer key with choices as referential rule, inferential rule, augmentation rule and reflexive rule for competitive exam prep. Free study guide is to learn functional dependencies quiz online with MCQs to practice test questions with answers.

MCQs on Functional Dependencies Quiz pdf Download

MCQ. Rule which states that addition of same attributes to right side and left side will results in other valid dependency is classified as

  1. referential rule
  2. inferential rule
  3. augmentation rule
  4. reflexive rule

C

MCQ. In reflexive rule (IR1), true dependencies generated are classified as

  1. trivial
  2. nontrivial
  3. inferential
  4. functional

A

MCQ. Extensions of relation that satisfy constraint of functional dependency are considered as

  1. legal extensions
  2. semantic extensions
  3. state extension
  4. relation extensions

A

MCQ. In functional dependency between two sets of attributes A and B then set of attributes A of database is classified as

  1. top right side
  2. down left side
  3. left hand side
  4. right hand side

C

MCQ. Rule which states that set of attributes determines any of its subset is classified as

  1. closure rule
  2. reflexive rule
  3. referential rule
  4. inferential rule

B