What is referential integrity ?

Answers were Sorted based on User's Feedback



What is referential integrity ?..

Answer / rajesh

To establish a parent child relationship between two tables
and to prevent invalid data entry into the table , we make
set of rules on a column is called Referential integrity.

Is This Answer Correct ?    5 Yes 0 No

What is referential integrity ?..

Answer / mallikarjuna.anumala

A rule defined on a column (or set of columns) in one table
that allows the insert or update of a row only if the value
for the column or set of columns (the dependent value)
matches a value in a column of a related table (the
referenced value). It also specifies the type of data
manipulation allowed on referenced data and the action to
be performed on dependent data as a result of any action on
referenced data.

Is This Answer Correct ?    3 Yes 0 No

What is referential integrity ?..

Answer / pravin kadam

A rule defined on a column (or set of columns) in one table
that allows the insert or update of a row only if the value
for the column or set of columns (the dependent value)
matches a value in a column of a related table (the
referenced value). It also specifies the type of data
manipulation allowed on referenced data and the action to
be performed on dependent data as a result of any action on
referenced data.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is difference between stored procedures and application procedures?

0 Answers  


What is sql resultset?

0 Answers  


what is meant by forward declaration in functions?

4 Answers   TCS,


what is the difference between truncate and drop statements? : Sql dba

0 Answers  


Define overloaded procedure?

0 Answers  






Can a table contain multiple primary key’s?

0 Answers  


how to get help information from the server? : Sql dba

0 Answers  


What are string functions in sql?

0 Answers  


What are the disadvantages of not performing database normalization?

0 Answers  


How to call the function and Procedure in trigger?

3 Answers   IBM,


Is full outer join same as cross join?

0 Answers  


what is difference between pass by value and eference by value in oracle plsql

1 Answers  


Categories