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

Discussion

The phrase "SALE.CNumber must exist in CUSTOMER.CNumber" is a referential integrity constraint.

  • A.True
  • B.False

Answer: A

Correct answer: True

A referential integrity constraint requires that every value appearing in a foreign key already exist as a key value in the referenced relation, which is exactly what this phrase states. It is enforced by the database rather than by the application, and it is what prevents a sale from referring to a customer who does not exist.

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

Post your comment

Please log in or register to post a comment.