What is referential integrity? What are the advantages of it?
- 4 Answers
- 30152 Views
- Descon, Digital Domain, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / anand
Referential integrity
Referential integrity in a relational database is
consistency between coupled tables. Referential integrity
is usually enforced by the combination of a primary key or
candidate key (alternate key) and a foreign key. For
referential integrity to hold, any field in a table that is
declared a foreign key can contain only values from a
parent table's primary key or a candidate key. For
instance, deleting a record that contains a value referred
to by a foreign key in another table would break
referential integrity. A relational database management
system (RDBMS) enforces referential integrity, normally
either by deleting the foreign key rows as well to maintain
integrity, or by returning an error and not performing the
delete. Which method is used would be determined by the
referential integrity constraint, as defined in the data
dictionary.
| Is This Answer Correct ? | 44 Yes | 7 No |
Answer / daynik
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 ? | 11 Yes | 5 No |
Answer / rajdeo kumar
it show referance to another location with accuracy.
| Is This Answer Correct ? | 10 Yes | 28 No |
If there exist a index on the table, and we then make a view on that table (include the indexed column from base table) than why do we require indexing on view?Doesnt it create an overhead?
What are acid properties of transaction?
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
What is the sql server agent?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
What is indexed view? How to create it?
What is indexing explain it with an example?
What are the different Authentication modes in SQL Server and how can you change authentication mode?
How to select true false based on column value in sql server?
How to create a dynamic cursor with the dynamic option?
How to end a stored procedure properly in ms sql server?
How can you append an identity column to a temporary table?
-
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)
