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 |
Does sql use python?
What is a primary key? Explain
What does pl sql developer do?
Explain the working of primary key?
How do you modify a column in sql?
Explain clause in sql?
What is a sql statement?
Is sqlexception checked or unchecked?
Explain what is table in a database?
How to move files from one directory to another in pl sql?
How to Declare Fixed Length String Value In PL SQL
How to disable a trigger name update_salary?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)