Microsoft Technology Associate Mta · Free Practice Question Hard
Question 10
Which two of the following statements are true?
-
A
In the first normalized form (1NF), the data is in an entity format, which basically means that the following three conditions must be met:
the table must have no duplicate records,
the table must not have multi-valued attributes,
and the entries in the column or attribute must be of the same data type.
-
B
The third normal form (3NF) ensures that all non-key attributes are fully functionally dependent on the primary key
-
C
The second normal form (2NF) checks for transitive dependencies. A transitive dependency is similar to a partial dependency in that they both refer to attributes that are not fully dependent on a primary key.
-
D
The fourth normal form (4NF) revolves around removing multi-valued dependencies.
Reveal correct answers
Correct answers: A, D
Explanation
The second normal form (2NF) ensures that all non-key attributes are fully functionally dependent on the primary key
The third normal form (3NF) checks for transitive dependencies. A transitive dependency is similar to a partial dependency in that they both refer to attributes that are not fully dependent on a primary key.
Therefore, the only correct answers can be that of the 1st Normal form and that of the 4th Normal form.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
