Functional Dependencies MCQs Test Online PDF Book Download

Functional dependencies multiple choice questions (MCQs), functional dependencies test prep for online learning with IT degree certificate eCourses. Learn functional dependencies and normalization multiple choice questions (MCQs), functional dependencies quiz questions and answers. Career test on functional dependencies, database normalization of relations, normalization: second normal form, normalization: first normal form, equivalence of sets of functional dependency test for DBA in DBMS certification.

Learn functional dependencies and normalization practice test MCQs: in reflexive rule (ir1), true dependencies generated are classified as, for free online courses with options trivial, nontrivial, inferential, functional for MIS careers. Free skills assessment test is for e-learning online functional dependencies quiz questions for competitive assessment in computer science major for Microsoft SQL certification.

MCQ on Functional DependenciesQuiz Book 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