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 the difference between jpql and sql?
What is difference between table and view?
What is sap sql?
Is sql easier than java?
i declare 4 procedure in package specification but in package body i write only 3 procedure. is it complie??//w
4 Answers Scope International,
Is sql database free?
What is the difference between delete and truncate commands?
What is the difference between left outer join and left join?
What are the advantages of VIEW?
What is procedure function?
What is the advantage of index in sql?
What are schema-level triggers?
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)