Interested to Buy Any Domain ? << Click Here >> for more details...
What is referential integrity? What are the advantages of it?
- 4 Answers
- 31155 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
What is advantage data architect?
Can we install sql server 2016 on windows 7?
What is outer join in sql server joins?
Explain active/passive and active/active cluster configurations?
List some major differences between triggers and stored procedures?
How can you list all the columns in a database?
How to create a view on an existing table in ms sql server?
When would you use a before or after trigger?
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
What is the difference between index seek vs. Index scan?
What is the difference between ddl and dml?
What is dbcc? Give few examples.
How to update muliple row in single query?
What do you understand by triggers?
What is truncate table?
