IndiaBIX

Database - The Relational Model and Normalization

Exercise : The Relational Model and Normalization - General Questions
1.
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 → B.
A → C.
A → (B,C).
(B,C) → A.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
2.
The different classes of relations created by the technique for preventing modification anomalies are called:
normal forms.
referential integrity constraints.
functional dependencies.
None of the above is correct.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
3.
A relation is in this form if it is in BCNF and has no multivalued dependencies:
second normal form.
third normal form.
fourth normal form.
domain/key normal form.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
4.
Row is synonymous with the term:
record.
relation.
column.
field.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
5.
The primary key is selected from the:
composite keys.
determinants.
candidate keys.
foreign keys.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers