Advanced Database Management System - Tutorials and Notes: Quiz on normalization and functional dependency 6

Friday, 26 June 2015

Quiz on normalization and functional dependency 6

Relational model and Normalization Quiz


1. Functional dependency analysis helps in the normalization of a relational schema. TRUE / FALSE?
    TRUE
    FALSE

2. Normalization attempts to reduce redundant information that are stored as part of a relation. TRUE/FALSE?
    TRUE
    FALSE

3. Redundancy is at the root of insertion and deletion anomalies in a relational database. TRUE/FALSE?
    TRUE
    FALSE

4. A null value has exactly one interpretation, ie., one meaning. TRUE/FALSE?
    TRUE
    FALSE

5. A functional dependency is a relationship between an attribute "Y" and a determinant (1 or more other attributes) such that for a given value of a determinant the value of the attribute Y is uniquely defined. TRUE/FALSE?
    TRUE
    FALSE

6. Functional dependencies can be found out algorithmically (automatically) by analysis of the relation. No semantic analysis is required. TRUE/FALSE?
    TRUE
    FALSE

7. In practical terms, we want non-key attributes to be functionally dependent on the primary key in any relation. TRUE/FALSE?
    TRUE
    FALSE

8. Transitivity of functional dependencies means that if a →b and a→c then c→b. TRUE/FALSE?
    TRUE
    FALSE

9. Decomposition of functional dependencies would mean that if a→bc then a→b and a→c. TRUE/FALSE?
    TRUE
    FALSE

10. Functional dependencies are reflexive, i.e., if a →b then b →a. TRUE/FALSE?
    TRUE
    FALSE

Score =

Correct answers:

No comments:

Post a comment

Featured Content

Multiple choice questions in Natural Language Processing Home

MCQ in Natural Language Processing, Quiz questions with answers in NLP, Top interview questions in NLP with answers Multiple Choice Que...

All time most popular contents