Interested to Buy Any Domain ? << Click Here >> for more details...
What is referential integrity? What are the advantages of it?
- 4 Answers
- 31522 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
How can you set the threshold at which sql server will generate keysets asynchronously?
Can sql server be linked with other servers like oracle?
How can I create a report based on a query? : sql server management studio
Explain timestamp datatype?
Explain multiserver query
What is indexed view? How to create it?
What is rs.exe utility?
What are the different methods available under sqlcommand class to access the data?
What is the maximum row of a size?
What are the system database in sql server 2005?
What does set rowcount do?
What are subquery and its properties?
What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas
Explain concepts of analysis services?
List down some advantages of sql stored procedure?
