nerdexam
Microsoft

98-364 · Question #118

John works as a Database Administrator for Bluewell Inc. The company has a SQL Server database. A table in the database has a candidate key and an attribute that is not a constituent of the…

The correct answer is B. 2 NF. See the full explanation below for the reasoning.

Question

John works as a Database Administrator for Bluewell Inc. The company has a SQL Server database. A table in the database has a candidate key and an attribute that is not a constituent of the candidate key. The non-key attribute depends upon the whole of the candidate key rather than just a part of it. Which of the following normal forms is represented in the scenario?

Options

  • A4 NF
  • B2 NF
  • C1 NF
  • D3 NF

How the community answered

(29 responses)
  • A
    10% (3)
  • B
    69% (20)
  • C
    3% (1)
  • D
    17% (5)

Community Discussion

No community discussion yet for this question.

Full 98-364 Practice