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
Give a brief description of db2 isolation levels?
What is view db2?
What is null indicator in db2?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
How does db2 sample database connect?
What is the picture clause of null indicator variable?
Explain in detail about buffer manager and its functionalities?
What is a db2 schema?
What is cursor stability in db2?
How do I import a csv file into db2?
What is table space in db2?
What is a collection in db2?
Differentiate between cs and rr isolation levels? Where do you specify them?
What is the reason behind not using select * in embedded sql programs?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
