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 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
How do you stop a db2 database in linux?
How can i install db2 9.x on AIX based system..? plz reply the detailed steps involved....?
How do you retrieve the first 5 characters of firstname column of db2 table emp?
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
Explain package in db2 and its advantages?
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?
Usually, which is more important for DB2 system performance - CPU processing or I/O access?
what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........
what is Static and dynamic linking
What is view db2?
what is datacom db?