Theory Of Database Quiz 7 Bscs2a

10 Questions | Total Attempts: 42

SettingsSettingsSettings
Please wait...
Theory Of Database Quizzes & Trivia

Choose the letter of the correct answer


Related Topics
Questions and Answers
  • 1. 
    It is defined as the process of applying a series of techniques and rules to a database in order to reduce data redundancy
    • A. 

      Normalization

    • B. 

      Normal form

    • C. 

      Projection

  • 2. 
    it is a description of the rules that a database at a certain level of normalization must follow
    • A. 

      Key attribute

    • B. 

      Mutual independence

    • C. 

      Non-key attribute

    • D. 

      Determinant

  • 3. 
    it is a description of the rules that a database at a certain level of normalization must follow
    • A. 

      Normalization

    • B. 

      Normal form

    • C. 

      Projection

  • 4. 
    This condition exists among attributes within a relation if none of them are functionally dependent on any combination of the others
    • A. 

      Key attribute

    • B. 

      Non-key attribute

    • C. 

      Determinant

    • D. 

      Mutual independence

  • 5. 
    If a table is in second normal form.
    • A. 

      It is also in first normal form

    • B. 

      It is also in third normal form

    • C. 

      It does not contain any transitive dependencies

    • D. 

      It contains attributes that are not fully functionally dependent on the key

  • 6. 
    It is a normal form that states that all underlying simple domains contain atomic values only.
    • A. 

      3NF or Third Normal Form

    • B. 

      2NF or second normal form

    • C. 

      1NF or First normal form

    • D. 

      Normalization

  • 7. 
    If a table is in third normal form
    • A. 

      It is also in Boyce-Codd normal form

    • B. 

      It contains non-atomic attributes

    • C. 

      It does not contain any transitive dependencies

    • D. 

      It contains attributes that are not fully functionally dependent on the key

  • 8. 
    It is a normal form that states that every nonkey attribute is fully dependent on the primary key.
    • A. 

      3NF or Third Normal Form

    • B. 

      2NF or second normal form

    • C. 

      1NF or First normal form

    • D. 

      Normalization

  • 9. 
    It is a normal form if and only if every determinant is a candidate key
    • A. 

      3NF or Third Normal Form

    • B. 

      2NF or second normal form

    • C. 

      1NF or First normal form

    • D. 

      BCNF or Boyce-Codd normal form

  • 10. 
    It is a normal form if and only if it is in 2NF and every non-key attribute is nontransitively dependent on the primary key.
    • A. 

      3NF or Third Normal Form

    • B. 

      2NF or second normal form

    • C. 

      1NF or First normal form

    • D. 

      Normalization