What is Referential Integrity?
- 3 Answers
- 11813 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / suriyaraj
Referential integrity is a database concept that ensures
that relationships between tables remain consistent. When
one table has a foreign key to another table, the concept
of referential integrity states that you may not add a
record to the table that contains the foreign key unless
there is a corresponding record in the linked table. It
also includes the techniques known as cascading update and
cascading delete, which ensure that changes made to the
linked table are reflected in the primary table.
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / rajeshwaran
It is a rule defined on a column or a set of columns that
allows to insert or update a value in a table that matches
with the values in the corresponding columns of the related
tabels.
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / dhirendra
Referential Integrity means: Whenever parent values are
available, the user can not transact it to Transaction table.
| Is This Answer Correct ? | 0 Yes | 1 No |
write the Sql query for creating database backup?
What is difference between nchar and nvarchar?
What is where clause in sql?
what are date and time functions in mysql? : Sql dba
What are sql ddl commands?
What is partition in sql query?
what is normalization? : Sql dba
How can the performance of a trigger be improved?
What is type and rowtype in pl sql?
How packaged procedures and functions are called from the following?
Is coalesce faster than isnull?
how can you create an empty table from an existing table? : Sql dba
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
