Dependencies and Normal Forms Multiple Choice Questions (MCQ) PDF Download

MCQ 1: The normal form which consider all the types of constraints and dependencies is classified as

1. domain-key normal form
2. foreign-key normal form
3. candidate-key normal form
4. primary-key normal form

MCQ 2: The template conclusion is a set of tuples that must be included in the relations in the template dependency called

1. constraint generating templates
2. tuple generating templates
3. schema generating templates
4. relation filtering template

MCQ 3: The types of template dependencies are

1. constraint generating templates
2. tuple generating templates
3. schema generating templates
4. both a and b

MCQ 4: The conclusion of the template is a condition which must be held on tuples hypothesis in the template dependency called

1. schema generating templates
2. relation filtering template
3. constraint generating templates
4. tuple generating templates