What is meant by repeatable read?

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

(Continued from previous question...)

What is meant by repeatable read?

When an application program executes with repeatable read protection, rows referenced by the program can't be changed by other programs until the program reaches a commit point.

(Continued on next question...)

Other Job Interview Questions

• What is the Manimum number of volumes that can be added to a STOGROUP?
• How do you simulat the EXPLAIN of an embedded SQL statement in SPUFI/QMF ?
• What is the difference between join and union ?
• What are the Maximum and minimum, number of partitions allowed in a partition tablesspace?
• What do you need to do before you do EXPLAIN?
• What will the FREE command do to a plan?
• DB2 can implement a join in three ways using a merge join...
• Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2
• What is a lock?
• What is the Manimum number of volumes that can be added to a STOGROUP?
• More...