what types of copies can be made with the COPY Utility ?
What are foreign keys?
When do you specify the isolation level? How?
What is copy pending and check pending in db2?
What is RUNSTATS?
what are the max. & min. no. of partitions allowed in a partition tablespace?
What are the Isolation levels possible ?
What is the difference between cursor and select statement?
what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)
how can u nderstand the sql stmts executed successfully or not ?
Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?
What is buffer pool?
what is the process of precompiler?