What is referential integrity? What are the advantages of it?

Answers were Sorted based on User's Feedback



What is referential integrity? What are the advantages of it?..

Answer / anand

Referential integrity
Referential integrity in a relational database is
consistency between coupled tables. Referential integrity
is usually enforced by the combination of a primary key or
candidate key (alternate key) and a foreign key. For
referential integrity to hold, any field in a table that is
declared a foreign key can contain only values from a
parent table's primary key or a candidate key. For
instance, deleting a record that contains a value referred
to by a foreign key in another table would break
referential integrity. A relational database management
system (RDBMS) enforces referential integrity, normally
either by deleting the foreign key rows as well to maintain
integrity, or by returning an error and not performing the
delete. Which method is used would be determined by the
referential integrity constraint, as defined in the data
dictionary.

Is This Answer Correct ?    44 Yes 7 No

What is referential integrity? What are the advantages of it?..

Answer / 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

What is referential integrity? What are the advantages of it?..

Answer / rajdeo kumar

it show referance to another location with accuracy.

Is This Answer Correct ?    10 Yes 28 No

What is referential integrity? What are the advantages of it?..

Answer / ramakrishna

refrential nothing but forgein key

Is This Answer Correct ?    13 Yes 32 No

Post New Answer

More SQL Server Interview Questions

What is the use of commit?

0 Answers  


what are the types of indexes? : Sql server database administration

0 Answers  


What is the difference between HAVING clause and the WHERE clause?

7 Answers  


Is it possible to update the views? If yes, how, if not, why?

0 Answers  


What are the difference between data length and length in SQL Server-2008?

3 Answers   Scio Healthcare,






How do I start and stop sql server?

0 Answers  


What is #temp and @table variable in SQL server?

0 Answers  


What are the database roles? : sql server security

0 Answers  


What is an index in a database?

0 Answers  


Write a query to get all details of employee who has maximum salary from employee table

8 Answers   AON, Genpact,


Explain isolation levels that sql server supports?

0 Answers  


What are cursors and when they are useful?

0 Answers  


Categories