Functional Dependencies and Normalization Multiple Choice Questions 1 PDF Download

Learn functional dependencies and normalization multiple choice questions (MCQs), DBMS test 1 for online exams. Practice equivalence of sets of functional dependency MCQs questions and answers on equivalence of sets of functional dependency, normalization first normal form, normalization second normal form, database normalization of relations, functional dependencies with answers. Free functional dependencies and normalization quiz, online study guide has helping answer key with choices as e is covered by f, fd is covered by e, f is covered by e and fplus is covered by e of multiple choice questions as if every functional dependency in set e is also in closure of f then this is classified as to test learning skills for viva exam preparation and job's interview questions. Study to learn equivalence of sets of functional dependency quiz questions with online learning MCQs for competitive exam preparation test.

MCQ on Functional Dependencies and Normalization Quiz PDF Download Test 1

MCQ. If every functional dependency in set E is also in the 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. The form of dependency in which the set of attributes that are neither a subset of any of the keys nor the candidate key is classified as

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

A

MCQ. The 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. 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