dot Net Database Question: Download Questions PDF
Explain What is referential integrity and how can we achieve it?
Answer:
Referential integrity preserves the defined relationships between tables when records are entered or deleted. In SQL Server, referential integrity is based on relationships between foreign keys and primary keys or between foreign keys and unique keys. Referential integrity ensures that key values are consistent across tables. Such consistency requires that there be no references to nonexistent values and that if a key value changes, all references to it change consistently throughout the database.
We can achieve this by using foreign key.
We can achieve this by using foreign key.
Download dot Net Database Interview Questions And Answers
PDF
| Previous Question | Next Question |
| What is differences between ADO and DAO? | Explain the different types of replication? How are they used? |