What are distributed queries?

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

(Continued from previous question...)

What are distributed queries?

You can use distributed queries to access data from multiple heterogeneous data sources in single query statement. This allows you to distribute data to multiple MS SQL databases or even Oracle databases.

(Continued on next question...)

Other Job Interview Questions

• Is it true that MS SQL Server is sharing work load between the server and client computers?
• What is default sorting order when you use "ORDER BY" clause in a query statement?
• What can you do with the "ALTER DATABASE ..." T-SQL command?
• If you finish installing MS SQL Server as Named Instance, what would be the default path name on the hard disk where the server will be installed to?
• What is the difference between a "User DSN" and a "System DSN" ODBC connection?
• What is "bcp"?
• When "SET CONCAT_NULL_YIELDS_NULL ON", concatenating a null value with a string will yield a NULL result. But this only applies to the current session if you use in Query Analyzer. Is this true?
• What is the meaning of the NOTRUNCATE option in the "DBCC SHRINKDATABASE" command?
• What is the size of an Extent in MS SQL Server?
• What is a Rule is MS SQL Server?
• More...