Home > Articles > Data > MySQL

  • Print
  • + Share This
This chapter is from the book

This chapter is from the book

Quiz

  1. A superkey is

    1. A minimal key

    2. A foreign key

    3. A set of attributes that can be used to identify a single row in a table

    4. A minimal set of attributes that can be used to identify a single row in a table

  2. If a table is in second normal form

    1. It is also in first normal form

    2. It is also in third normal form

    3. It does not contain any transitive dependencies

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

  3. If a table is in third normal form

    1. It is also in Boyce-Codd normal form

    2. It contains non-atomic attributes

    3. It does not contain any transitive dependencies

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

  4. The three kinds of anomalies are

    1. insertion, selection, deletion

    2. insertion, update, deletion

    3. selection, update, deletion

  5. A tuple is

    1. a column

    2. a row

    3. a candidate key

    4. the birthplace of Elvis Presley

    5. a foreign key

  • + Share This
  • 🔖 Save To Your Account