Under what circumstances will DB2 allow an SQL statement to
update more than one primary key value at a time?



Under what circumstances will DB2 allow an SQL statement to update more than one primary key value..

Answer / vinod babu bachina

Never. Such processing could produce duplicate values
violating entity integrity. Primary keys must be updated one
at a time.

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More DB2 Interview Questions

How many Buffer pools are there in DB2 and what are they?

1 Answers   IBM,


What is ibm db2 used for?

0 Answers  


What are the three lock types?

2 Answers  


What are foreign keys in db2?

0 Answers  


Which isolation level provides highest data integrity?

0 Answers  


Outputs of explain are with matchcols = 0. What does this signify?

0 Answers  


What is the use of db2?

0 Answers  


What are PACKAGES ?

3 Answers  


What is cursor?

2 Answers  


how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE

10 Answers   IBM,


What is coalesce in db2?

0 Answers  


How to get Top 10 Salaries from a Table

11 Answers   Accenture, HTC,


Categories