What are the various locks available?

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

(Continued from previous question...)

What are the various locks available?

SHARE, EXCLUSIVE, UPDATE

(Continued on next question...)

Other Job Interview Questions

• What is lock escalation?
• Is BETWEEN inclusive of the range values specified? –
• What happens to the PLAN if index used by it is dropped?
• What are PACKAGES ? –
• What is a DBRM, PLAN ?
• Can you have more than one cursor open at any one time in a program ? –
• What are the various locking levels available?
• Can I use LOCK TABLE on a view?
• How do you select a row using indexes in DB2?
• What is lock escalation?
• More...