What is JOIN and different types of JOIN ?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is JOIN and different types of JOIN ?

The ability to join rows and combine data from two or more tables is one of the most powerful features of relational system. Three type of joins: 2. Non-equijoin
3. self-join

(Continued on next question...)

Other Job Interview Questions

• What is the Manimum number of characters that a tablename can have?
• What are the three tyes of page locks that can be held?
• Describe the elements of the SELECT Query syntax?
• What are the isolation levals possible ?
• How would you move a tablespace to a different DASD volume allocated to that tablespace?
• What are the three DB2 date and time data types and their associated functions?
• In a DB2-CICS program which is acts as co-ordinator and which is participant?
• What are the different methods of accessing DB2 from TSO?
• How many sub queries can you combine together?
• Explain what a plan?
• More...