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 meant by explain?
What os does db2 run on?
How to view db2 table structure?
How can you do the explain of a dynamic sql statement?
What is difference between alias and synonym in db2?
What is meant by union and union all?
What is the maximum length of sqlca?
How do I copy a table in db2?
When do you specify the isolation level?
What are the uses of db2 optimizer?
Is it possible using max on a char column?
How can deadlocks be resolved?
Who uses db2?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What is a db2 tablespace?