Database interview questions - IBM

1. What do you know about DB2?
2. Have you ever used it? Can you also explain some benefits of it?
3. What is indexing? Why you need it?
4. What is the difference between stored procedure and triggers?
5. What is the difference between truncate and delete commands?
6. What do you understand by join? Explain with one example?