When can an insert of a new primary key value threaten
referential integrity?

Answers were Sorted based on User's Feedback



When can an insert of a new primary key value threaten referential integrity?..

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

When can an insert of a new primary key value threaten referential integrity?..

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

Post New Answer

More DB2 Interview Questions

how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures

2 Answers   Accenture,


How do you stop a db2 database in linux?

0 Answers  


How can i install db2 9.x on AIX based system..? plz reply the detailed steps involved....?

0 Answers   IBM, TCS,


How do you retrieve the first 5 characters of firstname column of db2 table emp?

1 Answers  


Hi this is sures. i need to practice the ibm mainframes.could u telme how can i get userid from IBM.how much cost they will collect for one user id.can send me the details please.thanq

2 Answers  






Explain package in db2 and its advantages?

0 Answers  


In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?

1 Answers  


Usually, which is more important for DB2 system performance - CPU processing or I/O access?

1 Answers  


what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........

1 Answers  


what is Static and dynamic linking

1 Answers   Virtusa,


What is view db2?

0 Answers  


what is datacom db?

2 Answers   CSC,


Categories