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

Discussion

Referential Integrity constraints functions using the __________ concept.

  • A.Primary key
  • B.Super key
  • C.Foreign key
  • D.Secondary key

Answer: C

Referential integrity works through the Foreign key.

A referential integrity constraint says a value in one table must match a value in the table it refers to, for example every order's customer_id must exist in the customers table. The referring column is a foreign key, which references the primary key of the other table.

The primary key ensures each row of its own table is unique, a super key is any set of attributes that identifies rows, and a secondary key is an alternative search key. None of them links tables the way a foreign key does.

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

Post your comment

Please log in or register to post a comment.