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

SQL exercises for beginners one

SQL Exercises for Beginners / Simple SQL Exercises with Answers / Solved SQL exercises / SQL solved exercises with simple conditions / So...