nerdexam
Oracle

1Z0-060 · Question #151

Which normal form is a table in if it has no multi-valued attributes and no partial dependencies?

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.

Upgrading to Oracle Database 12c

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

How the community answered

(61 responses)
  • A
    2% (1)
  • B
    93% (57)
  • C
    3% (2)
  • D
    2% (1)

Why each option

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.

AFirst normal form

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.

BSecond normal formCorrect

Second Normal Form builds directly on First Normal Form by requiring that all attributes are atomic (eliminating multi-valued attributes) and that every non-key attribute is fully functionally dependent on the entire primary key, not just part of it. A partial dependency occurs when a non-key attribute depends on only a subset of a composite primary key, and 2NF specifically eliminates this condition. Together these two requirements precisely match what is described in the question.

CThird normal form

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.

DFourth normal form

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

Source: https://learn.microsoft.com/en-us/office/troubleshoot/access/database-normalization-description

Topics

#normalization#second normal form#partial dependencies#relational design

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice