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
- 7440 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 |
which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM
What are the various locks available?
What is meant by union and union all?
Can we update view in db2?
How to resolve deadlock issue
what is sql abend code -801,-802?
How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?
How do run the JCL which has 25 steps by skipping the following steps 5, 10,15 and 25 without using COND statement
can any one give the list of some important sql abend codes which r frequently asked in interviews?
What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?
What parameters are used to control the free space in DB2?
How can deadlocks be resolved?
COBOL 
