Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle

1 Answers   Infosys,


how to execute qcmdexc in rpgle?plz write code also?

1 Answers   IBM,


What is table space in db2?

0 Answers  


wht is d/f between union and joins ?

2 Answers  


When the like statement is used?

0 Answers  


What is the difference between primary key & unique index ?

6 Answers   Patni, Temenos,


What action db2 takes when a program aborts in the middle of a transaction?

0 Answers  


What does a deadlock mean in DB2?

0 Answers  


how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example

1 Answers   CTS,


Normalization in DB2 – first normal form, second normal form

4 Answers   Virtusa,


How will you delete duplicate records from a table?

7 Answers   Google,


How can you do the explain of a dynamic sql statement?

0 Answers  


Categories