What are the various locking levels available ?

DB2 ( IBM Database 2 ) Interview Questions

(Continued from previous question...)

What are the various locking levels available ?

PAGE, TABLE, TABLESPACE

(Continued on next question...)

Other Interview Questions

• What is the function of buffer manager ?
• What can the SET option of the repair Utility accomplish?
• What is a synonym?
• How do you leave the cursor open after issuing a COMMIT?
• What does CURRENTDATA option in bind indicate ?
• Explain an outer join ?
• What is the COBOL picture clause of the following DB2 data types?
• Compare a subselect to a join?
• What is a data type?
• What is the function of the Data Manager?
• More...