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

What is the meaning concurrency in the db2 database?

0 Answers  


On which levels locks can be applied?

0 Answers  


What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?

3 Answers   Cap Gemini,


what is copy pending and check pending ?

1 Answers   Xansa,


How many clustering indexes can be defined for a table?

2 Answers  






What is dbrm? What it contains? When it will be created?

0 Answers  


wt is view ? wht r the restrictions for view ?

3 Answers   Verizon,


What are the functions in DB2?

3 Answers   Satyam,


What is the syntax for seeing the columns and data types of a table in the db2 database?

0 Answers  


What is the use of dclgen in db2?

0 Answers  


How does db2 sample database connect?

0 Answers  


What is load replace in db2?

0 Answers  


Categories