What is referential integrity ?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
What is difference between stored procedures and application procedures?
What is sql resultset?
what is meant by forward declaration in functions?
what is the difference between truncate and drop statements? : Sql dba
Define overloaded procedure?
Can a table contain multiple primary key’s?
how to get help information from the server? : Sql dba
What are string functions in sql?
What are the disadvantages of not performing database normalization?
How to call the function and Procedure in trigger?
Is full outer join same as cross join?
what is difference between pass by value and eference by value in oracle plsql