Interested to Buy Any Domain ? << Click Here >> for more details...
When can an insert of a new primary key value threaten
referential integrity?
- 2 Answers
- 7488 Views
- Mind Tree, I also Faced
- E-Mail Answers
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 are the three lock types?
What is image copy?
If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?
Define check constraint.
How can you quickly find out the number of rows updated after an update statement?
What are union and union all?
How would you find out the total number of rows in a db2 table?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
Usually, which is more important for DB2 system performance - CPU processing or I/O access?
i want to maintain uniqueness on pdf without make lf??????????
What is the use of value function?
What is meant by dclgen?
COBOL 
