What are the various locking levels available?

What happens when you say OPEN CURSOR?

Can GROUP BY and ORDER BY used in a single query?

How would you display the table definitions (columns, data types of columns, constraints or default values set etc) of a table in QMF?

What are the disadvantages of using VARCHAR?

How can you quickly find out the number of rows updated after an update statement?

What technique can DB2 use to more effectively interpret data from EXPLAIN tables?

What are the three primary development environments for DB2?

Which is not one of the types of authorizations associated with a DB2 user?

How does one prepare a Java program that contains JDBC methods?

What must a SELECT statement be coded within?