Functional Dependency Theory Multiple Choice Questions (MCQ) PDF Download

MCQ : The universal-relation approach of a single schema defines the interactions of database along with

1. Users
2. Systems
3. Applications
4. Both A and C

MCQ 1: The process of creation of an E-R design tends to generate

1. 2NF designs
2. 3NF designs
3. 4NF designs
4. 5NF designs

MCQ 2: Multivalued dependencies helps in eliminate of some forms of

1. Redundancy
2. Isolation
3. Atomicity
4. Inconsistency

MCQ 3: A schema is said not to be in a desirable normal form, if its relationship sets are involving

1. One entity set
2. Two entity sets
3. More than two entity sets
4. No entity sets

MCQ 4: The normalization process can be done formally as part of

1. Data handling
2. Data processing
3. Data modeling
4. Data monitoring