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

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

This Question is published on Post your own questions
in New Interview (