SQL Server distributed queries questions and answers

Distributed queries access data from multiple heterogeneous sources. These data sources may or may not be stored on the same computer........
A linked server can be considered as another SQL server database running elsewhere. It can be a OLEDB or ODBC data source......
OPENQUERY is used to execute the specified query on the linked sever. OPENQUERY can be referenced in from the FROM clause just like a table name.........
OPENROWSET: Includes all connection information that is required to access remote data from an OLE DB data source.......