The Relational Model and Normalization Questions and Answers
The Relational Model and Normalization questions with answers form the foundation of modern database management systems. Frequently asked in programming interview questions with answers for TCS, Infosys, and Accenture, these concepts deal with structuring data using relations (tables) and applying normalization rules to reduce redundancy. Understanding primary keys, foreign keys, and dependencies allows candidates to design scalable databases. Solving relational model aptitude questions also improves logical thinking and query optimization skills essential for database developers and placement aspirants.
The Relational Model and Normalization
Showing 10 of
21 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.
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.
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.
5. The primary key is selected from the:
- composite keys.
- determinants.
- candidate keys.
- foreign keys.
6. Which of the following is a group of one or more attributes that uniquely identifies a row?
- Key
- Determinant
- Tuple
- Relation
7. When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):
- transitive dependency.
- insertion anomaly.
- referential integrity constraint.
- normal form.
8. A relation is considered a:
- Column.
- one-dimensional table.
- two-dimensional table.
- three-dimensional table.
9. In the relational model, relationships between relations or tables are created by using:
- composite keys.
- determinants.
- candidate keys.
- foreign keys.
10. A functional dependency is a relationship between or among:
- tables.
- rows.
- relations.
- attributes.