What is Referential Integrity?

Answers were Sorted based on User's Feedback



What is Referential Integrity?..

Answer / suriyaraj

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 ?    7 Yes 1 No

What is Referential Integrity?..

Answer / rajeshwaran

It is a rule defined on a column or a set of columns that
allows to insert or update a value in a table that matches
with the values in the corresponding columns of the related
tabels.

Is This Answer Correct ?    6 Yes 2 No

What is Referential Integrity?..

Answer / dhirendra

Referential Integrity means: Whenever parent values are
available, the user can not transact it to Transaction table.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More SQL PLSQL Interview Questions

how to get the third quarter of employee details from emp?

2 Answers   CompuTech,


what is the command for user data type?

2 Answers  


What is NOCOPY?

6 Answers   DELL,


Write the command to remove all players named sachin from the players table.

0 Answers  


Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

0 Answers  






what is Difference between Having and Where clause?

5 Answers   IBM,


What is a composite primary key?

0 Answers  


What does fetching a cursor do?

0 Answers  


What are different categories of sql commands?

0 Answers  


how to create object in plsql

2 Answers   TCS,


What are types of indexes in sql?

0 Answers  


how do you count the duplicate records in a table

10 Answers   Tech Mahindra,


Categories