31. What is meant by PACKAGES?
PACKAGES contain executable codes for SQL statements in respect of one DBRM.

32. What are the advantages of using PACKAGES?
When used, PACKAGES help avoid binding of large numbers of DBRM members in one plan. They also dispense with the cost of large BIND and avoid the entire transactions making them unavailable during BIND and automatic REBIND of the plan. Another advantage is that they minimize the fallback complexities when changes result in an error.

33. What is a collection?
A collection is a user-defined name that works as the anchor for packages but has no physical existence. It is used for the grouping of packages.

34. What is Dynamic SQL?
Dynamic SQL is the SQL statement created at the time of the execution of a program.

35. What is the picture clause of Null Indicator variable?
S9(4) COMP is the picture clause of a null indicator.

36. Which component checks DB2 deadlocks?
Locking services are provided by Locking services component which is known as Internal Resource Lock Manager (IRLM) and manages concurrency issues and dead locks.

37. Which component is responsible for execution of SQL statements?
Database services component is responsible for execution of SQL statements and it manages buffer pool also.

38. Which component handles DB2 startup and shutdown?
System services component handles DB2 startup and shutdown.

39. On which level we can apply the locks?
Locking can be applied on either of these - Page, table and table space.

40. In which step we specify the isolation level?
In Bind step we specify the isolation level.