What is referential integrity? What are the advantages of it?
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
What do you mean by an execution plan? How would you view it?
What method is used by the Command classes to execute SQL statements that return single values?
What are the types of user defined functions in sql server?
what is package and it uses and how can u call a package
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
What is db stored procedure?
What is merge replication?
What are binary string data types in ms sql server?
What is wide table?
What is the difference function and stored procedure?
what is denormalization? : Sql server database administration
Differentiate between a having clause and a where clause.
What happens if strings are casted into wrong code pages in ms sql server?
Does a server store data?
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?