Oracle
1Z0-060 · Question #151
1Z0-060 Question #151: Real Exam Question with Answer & Explanation
The correct answer is B: Second normal form. A table is in Second Normal Form (2NF) when it satisfies First Normal Form (no multi-valued attributes) and has no partial dependencies - meaning every non-key attribute depends on the whole primary key.
Question
Which normal form is a table in if it has no multi-valued attributes and no partial dependencies?
Options
- AFirst normal form
- BSecond normal form
- CThird normal form
- DFourth normal form
Explanation
A table is in Second Normal Form (2NF) when it satisfies First Normal Form (no multi-valued attributes) and has no partial dependencies - meaning every non-key attribute depends on the whole primary key.
Common mistakes.
- A. First Normal Form only requires that all column values are atomic and eliminates repeating groups or multi-valued attributes, but it does not address partial dependencies on a composite key.
- C. Third Normal Form requires 2NF compliance plus the elimination of transitive dependencies (non-key attributes depending on other non-key attributes), which is a stricter condition not mentioned in the question.
- D. Fourth Normal Form addresses multi-valued dependencies between independent multi-valued facts about an entity, which is a more advanced concern beyond partial dependencies.
Concept tested. Database normalization - Second Normal Form (2NF) definition
Reference. https://learn.microsoft.com/en-us/office/troubleshoot/access/database-normalization-description
Community Discussion
No community discussion yet for this question.