DBA > Job Interview Questions > DB2 ( IBM Database 2 ) Interview Questions

What are the three lock types?

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

(Continued from previous question...)

What are the three lock types?

The three types are shared, update and exclusive. Shared locks allow two or more programs to read simultaneously but not change the locked space. An exclusive lock bars all other users from accessing the space. An update lock is less restrictive. It allows other transactions to read or acquire shared locks on the space.

(Continued on next question...)

Other Job Interview Questions