1. | Which popular network protocol is often used when transmitting data across a slow network? |
|
2. | Which data provider enables you to perform Multiple Active Result Set (MARS) queries? |
|
3. | Which three interfaces are available with the MDAC library? |
|
4. | When would it be a good idea to utilize ADO.NET as your data provider? |
|
Answers
1. | TCP/IP was designed to support transmissions across the Internet and is a good performer across a wide area network or a slow network. |
2. | SQL Native Client is a data provider that was introduced with SQL Server 2005. It was created to support some of the new features available with SQL Server 2005, such as MARS queries, database mirroring, query notifications, and the XML data type. |
3. | MDAC supports ODBC, OLE DB, and ADO. ODBC and OLE DB are useful when you need to query data sources outside of SQL Server, especially if you are programming in C++. ADO is your only option if you need to program using a scripting language like VBScript or JScript. |
4. | It is a good idea to use ADO.NET as your data provider when you are developing managed code for the .NET Framework. |