Functional Dependencies MCQs Quiz Online PDF Download

Learn functional dependencies MCQs, DBMS online test for distance education, free online courses prep. Practice functional dependencies and normalization multiple choice questions (MCQs), functional dependencies quiz questions and answers. DBA certification prep on database normalization of relations, normalization: second normal form, normalization: first normal form, functional dependencies tutorials for online applications of DBMS courses distance learning.

Study bachelors and masters degree courses' MCQs: rule which states that addition of same attributes to right side and left side will results in other valid dependency is classified as, for online data science degree programs with choices referential rule, inferential rule, augmentation rule, and reflexive rule with interview questions and answers for online pre-employment assessment of job seekers. Free skills assessment test is for online learn functional dependencies quiz questions with MCQs, exam preparation questions and answers.

MCQs on Functional DependenciesQuiz 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