DB2 Tough Questions (1 of 4)

I am writing this after returning from my busy schedule. When I am just relaxing with coffee (my favourite), I got superb idea to write some db2 questions.

Q1) Correlated subquery top-bottom-top approach

==>Take on line course-Buy courses/Technical mainframe- to your dream job/career

Q2)Non correlated subquery bottom-to-top fashion

Q3) Joins are performance worth than Subqueries.

Q4) Usage of ‘OR’ is preferable than UNION

Q5) The “=” states in where clause, is FULL OUTER JOIN

wait for my next questions..

Advertisements

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.