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




MySQL Tutorial
MySQL Tutorial
ISBN: 0672325845
EAN: 2147483647
Year: 2003
Pages: 261

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net