DB2 Tough Questions (1 of 4)

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

  1. Which approach normally followed while writing co-related sub-query?
    • Correlated subquery top-bottom-top approach
  2. ==>Take on line course-Buy courses/Technical mainframe- to your dream job/career
  3. Which approach normally followed for non-corelated sub query?
    • Non correlated subquery bottom-to-top fashion
  4. Which one JOINS or Subqueries better?
    • Joins are performance worth than Subqueries.
  5. Why OR is better than UNION?
    • Usage of ‘OR’ is preferable than UNION
  6. What is ‘=’ in where clause?
    • The “=” states in where clause, is FULL OUTER JOIN

References

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.