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
Is it possible to create the following trigger: before or after update trigger for each row?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
How to rename a column in the output of sql query?
how to use regular expression in pattern match conditions? : Sql dba
What are the different types of functions in sql?
What is structural independence and why is it important?
how to use like conditions? : Sql dba
Enlist some predefined exceptions?
What are the two types of periodical indexes?
Is left join faster than inner join?
Can we use loop in sql?
What is rownum and rowid?
Is hadoop a nosql?
What are the parameter modes supported by pl/sql?
what are date and time functions in mysql? : Sql dba