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
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
Define check constraint.
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
Is the primary key a clustered index?
What is null value in db2?
Explain package in db2 and its advantages?
What are the benefits of using the db2 database?
What is the role of schema in the db2 database?
What are db2 tables?
How do I delete a table in database?
Is db2 relational database?
What is ibm db2 database?
What is the function of logging in the db2 database?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
Mention the various locks that are available in db2.
