When can an insert of a new primary key value threaten
referential integrity?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / pawan
when the value violates the rule of primary key....new
insert value must be unique.
Is This Answer Correct ? | 1 Yes | 3 No |
What is a trigger in the db2 database?
What is dclgen (declaration generator)?
which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?
Suppose if I need to update a column, how you do that using cursor?
What are the contents of a dclmgen?
what is the role of the cursor in db2?
What is package in cobol db2?
List some fields from sqlca?
What is dpf in db2?
Which component is responsible for db2 startup and shutdown?
what's the error code for Unique Index Violation?
Name some fields from SQLCA