Under what circumstances will DB2 allow an SQL s

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

Under what circumstances will DB2 allow an SQL satement ...

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

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

(Continued on next question...)

Other Job Interview Questions

• Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2
• Once you create a view, where would information about the view be stored?
• Can ALl Users Have The Privilege To Use The SQL Statement Select * (DML) ?
• Which transaction use a command thread?
• What is an alias and how does it differ from a synonym?
• What is the SQL Communicaions Area and what are some of its key fields?
• Usually, which is more important for DB2 system performance
• What is a DB2 access path?
• What is a synonym?
• How many buffer pools are available in DB2
• More...