Machine-translated by Google. Questions are authored in English.
Top

Discussion

If a denormalization situation exists with a one-to-one binary relationship, which of the following is true?

  • A.All fields are stored in one relation.
  • B.All fields are stored in two relations.
  • C.All fields are stored in three relations.
  • D.All fields are stored in four relations.

Answer: A

Correct answer: All fields are stored in one relation.

In a one-to-one relationship each row on either side matches at most one on the other, so the two relations can be merged with no duplication of any value. That is why this is the safest case for denormalisation - the join is removed and nothing is repeated in exchange.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.