Describe Referential Integrity ?

Answer Posted / orawhiz

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 ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many data types are supported?

610


What is sharded cluster?

516


Explain about the analyze command in oracle?

579


Oracle

1843


How many types of cluster table in Oracle?

571






What is user managed backup in Oracle?

609


What is blob data type in oracle?

555


Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

604


I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

1694


What privilege is needed for a user to create tables in oracle?

546


if you ctreate table identity

1843


What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

606


How to open and close an explicit cursor in oracle?

573


Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1477


how do u setup a replication site?

1494