Interested to Buy Any Domain ? << Click Here >> for more details...
What is referential integrity? What are the advantages of it?
- 4 Answers
- 31313 Views
- Descon, Digital Domain, I also Faced
- E-Mail Answers
Answer Posted / daynik
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 ? | 11 Yes | 5 No |
Post New Answer View All Answers
Can we delete data from a view?
What are indexers?
Does table partitioning improve performance?
Explain about Views?
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
Can binary strings be converted into numeric or float data types?
Where do you find the default Index fill factor and how to change it?
Tell me what is log shipping?
Explain what is analysis service repository?
What is nolock hint in sql server 2008
what stored procedure would you use to view lock information? : Sql server administration
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
what are the different stages of Report Processing?
What does it mean to normalize a database and why would you do it?
What is the difference between local and global temporary tables?
