What is a DB2 access path?

How does DB2 determine which lock-size to use?

What is a DB2 bind?

Which is not true for a segmented table space?

When is the access path determined for dynamic SQL?

If a user accidentally drops a table and commits work, which of the following recovers the dropped table?

Which DB2 object allows multiple users to access data in a table with each user only being able to access certain portions of the data?

When working with concurrency controls, what happens when the number of locks held on rows and tables is equal to the percentage of the locklist specified by maxlocks?

Why is the deadlock detector an important part of DB2 architecture?

Given the code: EXEC SQL DECLARE cursor1 CURSOR FOR SELECT name, age, b_date FROM person; EXEC SQL OPEN cursor1; Under which of the following situations will the above cursor be implicitly closed?

Why is a primary key needed on a table?