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 the result of open cursor statement?
How to create backup table in db2?
How do I delete a column in db2?
What is cursor in dbms?
Which is faster delete or truncate?
Name the lockable units in DB2?
How do I add a column to an existing table in db2?
How can you classify the locks in db2?
What are the full forms of spufi and dclgen and why are they used?
How and when does the db2 enforces the unique key?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is performance tuning db2?
What is ibm db2 database?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is difference between rollback and commit?
