Functional Dependencies MCQs & Quiz Online PDF Download

Functional dependencies MCQs, functional dependencies quiz answers pdf to study online DBMS course. Learn functional dependencies and normalization Multiple Choice Questions and Answers (MCQs), "functional dependencies" quiz questions and answers for computer science programs. Learn functional dependencies, relation schemas design, normalization: first normal form test prep for computer software engineer.

"The rule which states that addition of same attributes to the right side and left side will results in other valid dependency is classified as" Multiple Choice Questions (MCQ) on functional dependencies with choices referential rule, inferential rule, augmentation rule, and reflexive rule for computer science programs. Practice merit scholarships assessment test, online learning functional dependencies quiz questions for competitive exams in computer science major for cheapest online computer science degree.

MCQs on Functional Dependencies PDF Download

MCQ: The rule which states that addition of same attributes to the 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 the reflexive rule (IR1), the true dependencies generated are classified as

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

A

MCQ: The extensions of relation that satisfy the constraint of functional dependency are considered as

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

A

MCQ: In the functional dependency between two sets of attributes A and B then the 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: The 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