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

Is left join inner or outer?

759


how many values can the set function of mysql take? : Sql dba

720


What is foreign key sql?

748


What is sql architecture?

745


Can we insert data in view?

691






How to revise and re-run the last sql command?

835


how to fetch alternate records from a table? : Sql dba

825


Which is faster count (*) or count 1?

757


What are analytic functions in sql?

743


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

922


Can we join same table in sql?

736


Is truncate ddl or dml?

751


In pl/sql, what is bulk binding, and when/how would it help performance?

734


How many clustered indexes can you have?

726


What is partition by in sql?

784