1.

What Is "referential Integrity"?

Answer»

A FEATURE provided by relational database management systems (RDBMS) that prevents users or applications from ENTERING inconsistent data. For example, suppose Table B has a FOREIGN key that POINTS to a field in Table A.

  • Referential integrity would prevent from adding a record to Table B that cannot be linked to Table A.
  • Referential integrity rules might also specify that WHENEVER you delete a record from Table A, any records in Table B that are linked to the deleted record will also be deleted. This is called cascading delete.
  • Referential integrity rules could specify that whenever youmodify the value of a linked field in Table A, all records in Table B that are linked to it will also be modified accordingly. This is called cascading update.

A feature provided by relational database management systems (RDBMS) that prevents users or applications from entering inconsistent data. For example, suppose Table B has a foreign key that points to a field in Table A.


Discussion

No Comment Found

Related InterviewSolutions