What are the various locks available?

DB2 ( IBM Database 2 ) Interview Questions

(Continued from previous question...)

What are the various locks available?

SHARE, EXCLUSIVE, UPDATE

(Continued on next question...)

Other Interview Questions

• How would you print the output of an SQL statement from SPUFI?
• What does the REORG Utility?
• What is the Manimum Length SQLCA and what is the content of SQLCABC?
• What keyword does an SQL SELECT statement use for a string search?
• What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?
• Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2
• What does the CHECK Utility do?
• What is a DB2 bind?
• What is normalization and what are the five normal forms?
• Compare a subselect to a join?
• More...