|
Question: You are an ASP.NET developer and developing an application for you company. Your company uses Microsoft SQL server 6.5 as the database server. Your application produce an accounting summary reports based on a table containing millions of rows and you want to retrieve the summary reports as quickly as possible. Now you want your application to connect to the database and get the data as quickly as possible, which action should you take? A. Use SqlConnection object to connect to the database and SqlCommand object to run a stored procedure that returns the data. B. Use OleDbConnection object for database connection and OleDbCommand object to run a stored procedure that returns the data. C. Make Sql server to support HTTP access and provide an XML template to run a stored procedure that retrieves the data in XML format D. Use COM interop to create an ADODB.Connection object, and use an ADODB.Command object to run a SQL statement that returns the data. Correct Answer: B Explanation: We need to use an OleDBConnection to connect to SQL Server Version 6.5 (or earlier). Incorrect Answers A: SqlConnection object is not supported by SQL server 6.5. C: This is not an appropriate choice; HTTP functionality is not required in this scenario. D: ADODB is a legacy standard and should not be used here. |
| Sponsored Links: |
| << back |