Under what circumstances will DB2 allow an SQL statement to update more than o

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

Question Posted / guest

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

More DB2 Interview Questions

What is runstats db2?

How could one combine a set of incremental image copies into a single copy?

When Can you be sure that a query will return only one row?

Can a array declared with an index be displayed(readable format) in spool?

How to resolve -805 error in DB2?

What is null value in db2?

What's the difference between DB2 active log and archive log? Thanks a lot...

what is different three logs in DB2?

What is explain in db2?

What are the Isolation levels possible ?

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

What is the use of with ur in db2?

For more DB2 Interview Questions Click Here