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

Discussion

Which of the following columns is(are) are required in a table?

  • A.A foreign key
  • B.An alternate key
  • C.A primary key
  • D.A surrogate key.

Answer: C

Correct answer: A primary key

Every table must have a primary key, since without one its rows cannot be identified and duplicates cannot be prevented. Foreign keys appear only where the table participates as a child in a relationship, alternate keys only where more than one candidate exists, and a surrogate key only where one has been introduced deliberately.

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

Post your comment

Please log in or register to post a comment.