CommerceThe 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:
- A. composite keys.
- B. determinants.
- C. candidate keys.
- D. foreign keys.
Correct Answer: C
Row is synonymous with the term:
- A. record.
- B. relation.
- C. column.
- D. field.
Correct Answer: A
A relation is in this form if it is in BCNF and has no multivalued dependencies:
- A. second normal form.
- B. third normal form.
- C. fourth normal form.
- D. domain/key normal form.
Correct Answer: C
The different classes of relations created by the technique for preventing modification anomalies are called:
- A. normal forms.
- B. referential integrity constraints.
- C. functional dependencies.
- D. None of the above is correct.
Correct Answer: A
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:
- A. A →
- B. B. A →
- C. C. A → (B,C).
- D. (B,C) → A.
Correct Answer: A