What is the use of db2 optimizer?
What are the full forms of spufi and dclgen and why are they used?
Give a brief description of db2 isolation levels?
What is db2 and what is the use of db2 optimizer?
Mention data types used in db2 ?
Explain the contention situations caused by locks?
What is buffer pool and list some of them?
What is meant by union and union all?
Explain package in db2 and its advantages?
List few disadvantages of file processing system.
How index hunting contributes in improving the query performance?
Enlist the types of cursor?
What is join? Mention its types.
Mention the types of join?
How many types of database language exist?