What is the meaning of an Inner 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 Inner Join operatin of two tables?

The Inner Join operation of two tables returns only rows from both tables that meet the join condition.

(Continued on next question...)

Other Job Interview Questions

• What is the meaning of the NOTRUNCATE option in the "DBCC SHRINKDATABASE" command?
• What is the meaning of the following T-SQL command: EXEC sp_dboption 'OrderDB', 'single user', 'true'
• What are distributed queries?
• What is the meaning of the following T-SQL command: CREATE TABLE orders ...
• In what situation you should the "sp_showfilegroup" stored procedure?
• What is an Index in MS SQL Server?
• What can you do with the "ALTER DATABASE ..." T-SQL command?
• What is the use of *.ndf files in MS SQL Server?
• What stored procedure you can execute to find out if a database is set to single-user or multi-user mode?
• What does Constraint refer to in MS SQL Server?
• More...