Understanding DB2®: Learning Visually with Examples

11.10. Review Questions

1:	A batch operation is encountering lock escalations. If it is the only application running when the lock escalation occurs, which database configuration parameter can be used to reduce the lock escalations?
2:	Sam issues a SELECT statement that returns the following result set of three rows: Name Seat ---------------- Liu 1A Chong 14F Snow 3B Without committing or rolling back the current transaction, he issues the same SELECT statement again. The following is returned: Name Seat ---------------- - 1A Chong 14F Qi 3B Why is that?
3:	What database objects can a DB2 user explicitly lock using a DB2 command or statement?
4:	If an application holds a U lock on a row, what lock must another application request to access this ...