What is referential integrity ?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is denormalization in a database?

671


Does google use sql?

598


What is the use of sqlerrd 3?

598


how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

607


What is autocommit sql?

627






What is an exception in pl/sql?

638


How many types of privileges are available in sql?

849


what are the different type of normalization? : Sql dba

644


Explain how to use transactions efficiently : transact sql

622


Why functions are used in sql?

620


Do we need commit after truncate?

731


What is dcl in sql?

611


what is the difference between ereg_replace() and eregi_replace()? : Sql dba

650


What are the two virtual tables available at the time of database trigger execution?

756


how to include character strings in sql statements? : Sql dba

626