When can an insert of a new primary key value threaten
referential integrity?
Answer Posted / naveen
When this primary key is also a foreign key to another
table and that table is not having the value you are trying
to insert.
RI constraint doesn't allow you to insert a primary key
value into your table if its not present in table your are
having constraint with
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is lock escalation in db2?
How can you classify the locks in db2?
What is the difference between oracle and db2?
How to get the ddl of a table in db2?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What are the various isolation levels possible?
Define db2 and its databases?
What is coalesce in db2?
What is the latest version of ibm db2?
What are union and union all?
What is runstats db2?
What is the use of db2?
What is a bind card?
How does cobol compile db2 program?
What are the benefits of using the db2 database?