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 sql, mysql and sql server?
Explain cursor types?
How to run sql commands in sql*plus?
What is not null in sql?
Which software is used for pl sql programming?
What are the advantages and disadvantages, compared to the standard SQL and SQL*plus ?
Is ms sql traffic encrypted?
Explain spool.
What is sharding in sql?
What is join view in sql?
What is a recursive stored procedure?
How you improve the performance of sql*loader? : aql loader
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)