Data Models into Database Designs – True or False

16. (STREET ADDRESS, CITY, STATE, ZIP) is an ideal primary key.

A. True
B. False

Correct Answer:  B. False
Advertisement

17. When the parent entity is required and the parent has a surrogate key, update actions can be ignored.

A. True
B. False

Correct Answer:  A. True
Advertisement

18. When the parent entity is required, a new parent row can always be inserted.

A. True
B. False

Correct Answer:  A. True
Advertisement

19. For every relationship, there are six possible referential integrity actions.

A. True
B. False

Correct Answer:  A. True
Advertisement

20. An ideal primary key is short, numeric and seldom changing.

A. True
B. False

Correct Answer:  A. True
Advertisement

Leave A Comment?