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
Difference between truncate, delete and drop commands?
which types of join is used in sql widely? : Sql dba
what is acid property in database? : Sql dba
What is file based approach?
Can we insert data into materialized view?
What is pl sql collection?
What is the difference between local variables and global variables?
Why is nosql good?
Sql technical questions
Which are the different types of indexes in sql?
What is record in pl sql?
What is sql clause?
What is a null value?
What are the key differences between SQL and PL SQL?
Who developed sql?