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

which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?

3 Answers  


What is COPY PENDING status?

6 Answers  


which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM

3 Answers   Accenture,


What do you mean by NOT NULL? When will you use it?

3 Answers  


What is the physical storage length of timestamp data type?

0 Answers  






Explain the contention situations caused by locks?

0 Answers  


What can the Locate option of the Repair Utility accomplish?

2 Answers  


What should be specified along with a cursor in order to continue updating process after commit?

1 Answers   IBM,


Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

0 Answers  


how to check the table is empty or not?

3 Answers   IBM,


What is package versioning? Please give an example.

1 Answers  


what is + sign and -ve sign for sql code ?

1 Answers   TCS,


Categories