Home / CSE MCQs / DBMS MCQs :: Normal Forms - DBMS

CSE MCQs :: DBMS MCQs

  1. In the __________ normal form, a composite attribute is converted to individual attributes.
  2. A.
    First
    B.
    Second
    C.
    Third
    D.
    Fourth

    View Answer

    Workspace

    Discuss Discuss in Forum


  3. A table on the many side of a one to many or many to many relationship must:
  4. A.
    Be in Second Normal Form (2NF)
    B.
    Be in Third Normal Form (3NF)
    C.
    Have a single attribute key
    D.
    Have a composite key

    View Answer

    Workspace

    Discuss Discuss in Forum


  5. Tables in second normal form (2NF):
  6. A.
    Eliminate all hidden dependencies
    B.
    Eliminate the possibility of a insertion anomalies
    C.
    Have a composite key
    D.
    Have all non key fields depend on the whole primary key

    View Answer

    Workspace

    Discuss Discuss in Forum


  7. Functional Dependencies are the types of constraints that are based on______
  8. A.
    Key
    B.
    Key revisited
    C.
    Superset key
    D.
    None of these

    View Answer

    Workspace

    Discuss Discuss in Forum


  9. Which is a bottom-up approach to database design that design by examining the relationship between attributes:
  10. A.
    Functional dependency
    B.
    Database modeling
    C.
    Normalization
    D.
    Decomposition

    View Answer

    Workspace

    Discuss Discuss in Forum


  11. Which forms simplifies and ensures that there is minimal data aggregates and repetitive groups:
  12. A.
    1NF
    B.
    2NF
    C.
    3NF
    D.
    All of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum


  13. Which forms has a relation that possesses data about an individual entity:
  14. A.
    2NF
    B.
    3NF
    C.
    4NF
    D.
    5NF

    View Answer

    Workspace

    Discuss Discuss in Forum


  15. Which forms are based on the concept of functional dependency:
  16. A.
    1NF
    B.
    2NF
    C.
    3NF
    D.
    4NF

    View Answer

    Workspace

    Discuss Discuss in Forum


  17. Empdt1(empcode, name, street, city, state,pincode). For any pincode, there is only one city and state. Also, for given street, city and state, there is just one pincode. In normalization terms, empdt1 is a relation in
  18. A.
    1 NF only
    B.
    2 NF and hence also in 1 NF
    C.
    3NF and hence also in 2NF and 1NF
    D.
    BCNF and hence also in 3NF, 2NF and 1NF View Answer

    View Answer

    Workspace

    Discuss Discuss in Forum