Database Management System! Trivia Questions Quiz

10 Questions | Total Attempts: 77

SettingsSettingsSettings
Please wait...
Database Management System! Trivia Questions Quiz

.


Questions and Answers
  • 1. 
    Normal form is a state if a relation that results from applying simple rules regarding functional dependencies (or relationships between attributes) to that relation.
    • A. 

      TRUE

    • B. 

      FALSE

  • 2. 
    Determinants are the attribute on the left-hand side of the arrow in a functional dependency.
    • A. 

      TRUE

    • B. 

      FALSE

  • 3. 
    First Normal form is a relation in which every non-key attribute is fully functionally dependent on the primary key.
    • A. 

      TRUE

    • B. 

      FALSE

  • 4. 
    Partial functional dependency is a functional dependency between two (or more) nonkey attributes.
    • A. 

      TRUE

    • B. 

      FALSE

  • 5. 
    There are 3 major steps in normalization.
    • A. 

      TRUE

    • B. 

      FALSE

  • 6. 
    Normalization is the process of decomposing relations with anomalies to produce smaller, well-structured relations.
    • A. 

      TRUE

    • B. 

      FALSE

  • 7. 
    A candidate key is an attribute or combination of attributes, that uniquely identifies a row in a relation.
    • A. 

      TRUE

    • B. 

      FALSE

  • 8. 
    A functional dependency is a dependency in which one or more non-key attributes are functionally dependent on part (but not all) of the primary key.
    • A. 

      TRUE

    • B. 

      FALSE

  • 9. 
    1NF is a relation that has no transitive dependencies.
    • A. 

      TRUE

    • B. 

      FALSE

  • 10. 
    2NF contains no multivalued attributes.
    • A. 

      TRUE

    • B. 

      FALSE

Related Topics
Back to Top Back to top