Commerce

The Relational Model And Normalization MCQs

Practice The Relational Model And Normalization MCQs for competitive exams.

The Relational Model And Normalization MCQs

Practice questions from this topic.

The primary key is selected from the:

  1. A. composite keys.
  2. B. determinants.
  3. C. candidate keys.
  4. D. foreign keys.
Report Error

Row is synonymous with the term:

  1. A. record.
  2. B. relation.
  3. C. column.
  4. D. field.
Report Error

A relation is in this form if it is in BCNF and has no multivalued dependencies:

  1. A. second normal form.
  2. B. third normal form.
  3. C. fourth normal form.
  4. D. domain/key normal form.
Report Error

The different classes of relations created by the technique for preventing modification anomalies are called:

  1. A. normal forms.
  2. B. referential integrity constraints.
  3. C. functional dependencies.
  4. D. None of the above is correct.
Report Error

Every time attribute A appears, it is matched with the same value of attribute B, but not the same value of attribute C. Therefore, it is true that:

  1. A. A →
  2. B. B. A →
  3. C. C. A → (B,C).
  4. D. (B,C) → A.
Report Error