Functional Dependencies and Normalization Multiple Choice Questions and Answers 1 PDF Book Download

Functional dependencies and normalization multiple choice questions (MCQs), functional dependencies and normalization test prep to learn DBMS quiz 1 for CS degree free online courses. Learn equivalence of sets of functional dependency multiple choice questions (MCQs), functional dependencies and normalization quiz questions and answers. Free e-learning tutorial on equivalence of sets of functional dependency, normalization: first normal form, normalization: second normal form, database normalization of relations, functional dependencies test prep for Oracle certification.

Practice functional dependencies and normalization career test with multiple choice question: if there is more than one key for relation schema in dbms then each key in relation schema is classified as, for computer science majors with options super key, prime key, candidate key, primary key for online bachelor degree in computer science. Professional skills assessment test with learning online equivalence of sets of functional dependency quiz questions for computer science major, competitive assessment tests for Oracle database certification.

MCQ on Functional Dependencies & Normalization Test 1Quiz Book Download

MCQ: If every functional dependency in set E is also in closure of F then this is classified as

  1. FD is covered by E
  2. E is covered by F
  3. F is covered by E
  4. Fplus is covered by E

B

MCQ: If there is more than one key for relation schema in DBMS then each key in relation schema is classified as

  1. prime key
  2. super key
  3. candidate key
  4. primary key

C

MCQ: Form of dependency in which set of attributes that are neither a subset of any of keys nor candidate key is classified as

  1. transitive dependency
  2. full functional dependency
  3. partial dependency
  4. prime functional dependency

A

MCQ: Property of normalization of relations which guarantees that functional dependencies are represented in separate relations after decomposition is classified as

  1. nonadditive join property
  2. independency reservation property
  3. dependency preservation property
  4. additive join property

C

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