Which of the following is not created using an integrity constraint?
A)foreign key
B)primary key
C)composite key
D)surrogate key

Question

Quizplus · Accepted Answer

Foreign key, primary key, and composite key are all created using integrity constraints. However, surrogate keys are not inherently created using an integrity constraint. Surrogate keys are typically generated by the database management system and are used as a substitute for a natural key (i.e. a key that is based on the data attributes of an entity). While a surrogate key could be enforced using an integrity constraint, it is not necessarily created using one.

Which of the Following Is Not Created Using an Integrity