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

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

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

A. True
B. False

Correct Answer:  A. True

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

A. True
B. False

Correct Answer:  A. True

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

A. True
B. False

Correct Answer:  A. True

Leave A Comment?

three × 1 =