You cannot have an invalid entry in the foreign key column; at the same time, you cannot delete a vendor row as long as a product row references that vendor. This isknown as _____.
A) batch updating
B) referential integrity
C) authentication
D) cross joining

Question

Quizplus · Accepted Answer

The scenario described pertains to referential integrity. It ensures that the relationships between tables in a database are consistent and valid. It prevents invalid data from being inserted into a foreign key column and also prevents deleting of rows that are being referenced by another table. Batch updating, authentication, and cross joining are not relevant to this scenario.

You Cannot Have an Invalid Entry in the Foreign Key