What is the meaning of an Outer Join operatin of

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

(Continued from previous question...)

What is the meaning of an Outer Join operatin of two tables?

The Outer Join operation of two tables returns all rows from one table and rows from the other table that meet the join condition.

(Continued on next question...)

Other Job Interview Questions

• Where are database files and backup files of a MS SQL Server database located?
• What two categories you can divide T-SQL statements into?
• What is the "master" database? Can I delete it to save disk space?
• What is the size of an Extent in MS SQL Server?
• What can you do with the "ALTER DATABASE ..." T-SQL command?
• What is the T-SQL command to create a new login in MS SQL Server?
• Does MS SQL Server support IPX/SPX?
• What is the fully qualified naming convention to specify a table in a linked Oracle database from MS SQL server?
• What is the minimum of hard disk space required by MS SQL Server?
• What is a Stored Procedure in MS SQL Server?
• More...