What is the purpose of rollback and commit?
What is the role of data manager in the db2 database?
What parameters are used to control the free space in DB2?
How can you find out the # of rows updated after an update statement?
What is rebind in db2?
Mention the various locks that are available in db2.
What os does db2 run on?
What is the difference between drop table and delete table?
What are types of indexes?
Explain package in db2 and its advantages?
What is alias in db2?
Explain how can you do the explain of a dynamic sql statement?
How can you do the explain of a dynamic sql statement?
Why do we use cursor?
What is the difference between cursor stability and repeatable read isolation levels?