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 the STOSPACE Utility used for?
What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?
What is the clustering index in the db2 database?
How to create backup table in db2?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
How is the SUBSTR keyword used in sql?
Write a query to retrive partial string.
What is performance tuning db2?
Where are plans stored?
how to identify the pseudo conversation by seeing the program
Can you Average the Characters ?
What is DYNSLT keyword? How do you perform selection using DYNSLT