1.
What is the purpose of the Query Tuner?
2.
Which tool allows users to connect to a DB2 database using a wizard?
3.
What is the primary function of an Online Transaction Processing (OLTP) workload?
4.
Which isolation level offers the greatest protection of data but provides the least amount of concurrency?
5.
What factor influences lock escalation?
6.
Which type of lock allows the lock owner and all concurrent applications to read, but not update, the locked data?
7.
Application APP_A is performing updates to table TAB1 using the cursor stability (CS) isolation level. If application APP_B wants to retrieve all rows from table TAB1 without waiting for application APP_A to finish making updates, what isolation level must application APP_B use?
8.
Which statement will prevent concurrent application processes from performing anything other than read-only operations against a table named TAB1?
9.
When is an INTENT EXCLUSIVE (IX) lock required?
10.
What is the act of exchanging one lock an application holds on a resource for a more restrictive lock on the same resource known as?