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 |
how to resolve -805 . how to see dbrm and package not found
What is the difference between spufi and qmf?
what is main use of table space and index object? please its urgent
5 Answers CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,
What are concurrency issues?
How are write I/Os from the buffer pool executed?
Mention the location where the output received from explain statement is stored.
What does the REORG Utility do?
Why do chiropractors use drop table?
How does coalesce work?
What is dclgen (declaration generator)?
My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??
What are the advantages of using a PACKAGE?