Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / renu gupta
Referential integrity refers to the consistency that must
be maintained between primary and foreign keys.
1.An insert into primary key table cannot violate
referential integrity and no checking is required
2.A deletion of foreign key value can not violate
referential integrity and no checking is required
3.Changes in primary key is allowed only when those values
are not in foreign key.
4.Insert and updates in foreign key is allowed only when it
has a matching value in primary key
5. If RESTRICT is specified on foreign key definition,
deletion of primary key is not allowed
6. If CASCADE is specified, both primary and foerign keys
values can be deleted together only
7. If SET NULL is specified, then the foreign key value is
set null , provided nulls are allowed in the foreign key
column
| Is This Answer Correct ? | 12 Yes | 4 No |
Post New Answer View All Answers
What is universal database?
What is isolation level in db2?
Explain db2.
How do you select a row using indexes in db2?
What is the difference between cursor stability and repeatable read isolation levels?
What are the contents of dclgen?
How does a cursor work?
How do I change the column size in db2?
Is schema the same as database?
Why do chiropractors use drop table?
What is the physical storage length of timestamp data type?
What are the various isolation levels possible?
Outputs of explain are with matchcols = 0. What does this signify?
How do you stop a db2 database in linux?
What is bind in db2?
