Related InterviewSolutions

• How is INNER JOIN different from simply writing a JOIN?
• What is DCLGEN in DB2?
• As you know there are different sizes of locks. Can you tell how DB2 decides which lock size should be used?
• What are the two levels of isolation and what is the major difference between the 2 levels?
• How can you move a tablespace to a different DASD volume allocated to that tablespace if you have to use STOGROUP?
• What is MAX in DB2? Is it possible to use MAX in a CHAR column?
• What is a CURSOR and What is the use of it?
• What is concurrency in terms of DB2?
• What are UNION and UNION ALL in DB2? How do you differentiate between them?
• What is the difference between the above two queries i.e. DELETE and DROP?