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

Can I use LOCK TABLE on a view?

1 Answers  


what is a trigger and types of triggers

3 Answers   HSBC,


What is ACQUIRE/RELEASE in BIND?

3 Answers   Cognizant,


What is a Cartesian product?

2 Answers  


What is meant by isolation level?

3 Answers  






how can we retrieve the 100 records of the file ?

2 Answers   IBM,


What is dclgen (declaration generator)?

0 Answers  


which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit

2 Answers   Accenture, Wipro,


When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?

3 Answers  


What is temporal table in db2?

0 Answers  


What is the syntax of SELECT statement when embedded in a COBOL program?

2 Answers  


what is the use of bind parameter, Replace?

5 Answers   IBM,


Categories