Normalization Second Normal Form MCQs Quiz Online PDF Download

Practice normalization second normal form MCQs, DBMS test for online courses learning and test prep. Functional dependencies and normalization quiz has multiple choice questions (MCQ), normalization second normal form quiz questions and answers to learn.

Database management system test MCQ on form of dependency in which set of attributes that are neither a subset of any of keys nor candidate key is classified as with options transitive dependency, full functional dependency, partial dependency and prime functional dependency problem solving skills for viva, competitive exam prep, interview questions with answer key. Free study guide is for online learning normalization second normal form quiz with MCQs to practice test questions with answers.

MCQs on Normalization Second Normal Form Quiz PDF Download

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. Considering the functional dependency, the one in which removal of some attributes does not affect dependency is called

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

B

MCQ. The normalization form which is based on the transitive dependency is classified as

  1. first normal form
  2. second normal form
  3. fourth normal form
  4. third normal form

D

MCQ. Considering the functional dependency, the one in which removal from some attributes must affect dependency is called

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

A