DB2 can implement a join in three ways using a merge join,
a nested join or a hybrid join. Explain the differences?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB2 Interview Questions

where can we use index and subscript ? with example ?

3 Answers   CTS,


Mention the location where the output received from explain statement is stored.

0 Answers  


i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?

4 Answers  


How does coalesce work?

0 Answers  


What is meant by repeatable read?

4 Answers  


what is cursor stability?

2 Answers   IBM,


What is auditing?

2 Answers  


how can we retrieve the 100 records of the file ?

2 Answers   IBM,


When Can you be sure that a query will return only one row?

4 Answers   IBM,


What is a page?

2 Answers  


How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?

2 Answers   IBM, Tech Mahindra,


wht displays the number of times a query modified ?

2 Answers   TCS,


Categories