Download Aptitude Crack
img not found img not found

The Relational Model and Normalization - Technical MCQs

Q1:

A relation in this form is free of all modification anomalies.

A First normal form

B Second normal form

C Third normal form

D Domain/key normal form

ANS:D - Domain/key normal form

After a SQL database is in third normal form, you've eliminated most, but not all, chances of modification anomalies. Normal forms beyond the third are defined to squash those few remaining bugs.

Domain-key normal form (DK/NF):

Boyce-Codd normal form (BCNF), fourth normal form (4NF), and fifth normal form (5NF) are examples of such forms. Each form eliminates a possible modification anomaly but does not guarantee prevention of all possible modification anomalies. Domain-key normal form, however, provides such a guarantee.