What is a join and explain different types of jo

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

(Continued from previous question...)

What is a join and explain different types of joins.

Joins are used in queries to explain how different tables are related. Joins also let you select data from a table depending upon data from another table.

Types of joins: INNER JOINs, OUTER JOINs, CROSS JOINs. OUTER JOINs are further classified as LEFT OUTER JOINS, RIGHT OUTER JOINS and FULL OUTER JOINS.

(Continued on next question...)

Other Job Interview Questions

• Is SQL Server implemented as a service or an application?
• What is RAID and what are different types of RAID configurations?
• What’s the difference between a primary key and a unique key?
• How to determine the service pack currently installed on SQL Server?
• What's the maximum size of a row?
• What kind of LAN types do you know?
• What is the difference between them (Ethernet networks and token ring networks)?
• Let’s assume you have data that resides on SQL Server 6.5. You have to move it SQL Server 7.0. How are you going to do it?
• What's the difference between DELETE TABLE and TRUNCATE TABLE commands?
• Do you know how to configure DB2 side of the application?
• More...