Answer Posted / suriyaraj
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 ? | 7 Yes | 1 No |
Post New Answer View All Answers
What are sql commands?
What is a variable in sql?
What is the difference between nested table and varray?
What is an ndf file?
What is multiple columns?
What is meant by temporal data?
Which is faster subquery or join?
How to connect a sql*plus session to an oracle server?
What is data modelling in sql?
What are packages in pl sql and also explain its advantages?
Can there be 2 primary keys in a table?
How many commands are in sql?
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
How do we accept inputs from user during runtime?
What is sql*loader and what is it used for?