What is Referential Integrity?

Answer Posted / vasant

Referential integrity is a database concept that ensures
that relationships between tables remain consistent. When
one table has a foreign key to another table, the concept
of referential integrity states that you may not add a
record to the table that contains the foreign key unless
there is a corresponding record in the linked table. It
also includes the techniques known as cascading update and
cascading delete, which ensure that changes made to the
linked table are reflected in the primary table.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to convert character strings to dates? : Sql dba

530


Why do we use joins in sql?

512


Can a commit statement be executed as part of a trigger?

607


Can dml statements be used in pl/sql?

585


Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

679






How do I get sql certification?

535


which command using query analyzer will give you the version of sql server and operating system? : Sql dba

531


Is sql a dbms?

538


what is data integrity? : Sql dba

596


Do prepared statements prevent sql injection?

536


what is acid property in database? : Sql dba

564


Is sql better than excel?

523


what is view? : Sql dba

562


What does pragma mean?

515


What do you understand by pl/sql packages?

576