What is a lock?

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

(Continued from previous question...)

What is a lock?

A lock is the mechanism that controlls access to data pages and tablespaces.

(Continued on next question...)

Other Job Interview Questions

• How would you print the output of an SQL statement from SPUFI?
• Describe what a storage group (STOGROUP) is?
• What is the COBOL picture clause for a DB2 column defined
• What is SPUFI?
• DB2 can implement a join in three ways using a merge join...
• What is a correlated sub query?
• What is the database descriptor?
• I need to view the number of tables existing under one particular OWNER. Is it possible ? If so, please give the SQL query for this ?
• Are view updatable?
• In SPUFI suppose you want to selet maximum of 1000 rows ...
• More...