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
Explain about rct.
Is it possible using max on a char column?
What is the difference between using bind () and rebind () methods of naming class?
How can you quickly find out the # of rows updated after an update statement?
How to compare data between two tables in db2?
How to create backup table in db2?
What is data manager?
what is the responsibility of the construction superintendent
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
How to access db2 tables in mainframe?
Is db2 a database?
Which command is used to connect to a database in DB2 ? Give the Syntax.
what is db2 restart?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
i want to maintain uniqueness on pdf without make lf??????????
