Interested to Buy Any Domain ? << Click Here >> for more details...
What is referential integrity? What are the advantages of it?
- 4 Answers
- 31359 Views
- Descon, Digital Domain, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
What is SQL Azure Federations?
How global temporary tables are represented and its scope?
what is raid? : Sql server database administration
What are basics of policy management?
Explain the steps to use transact-sql cursor?
What is clustered index
Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration
What are drilldown reports?
What is the order by used for?
what is the sql equivaent of the dataset relation object ?
query processing
What is scalar user-defined function?
Where the sql logs gets stored? : sql server database administration
What is a subquery in a select query statement in ms sql server?
