单项选择题
You work as an application developer at Contoso.com. You use Microsoft .NET Framework 3.5 and Microsoft ADO.NET to develop an application that will connect to the Microsoft SQL Server 2005 database. You want to use Windows Authentication along with the Microsoft OLE DB provider. You now need to make sure that the OLE DB connection is as secure as possible.
What should you do？（）
A. Add the following parameter to the connection string： Integrated Security=true； PersistSecurityInfo=true；
B. Add the following parameter to the connection string： Integrated Security=SSPI；
C. Add the following parameter to the connection string： Integrated Security=SSPI； PersistSecurityInfo=yes；
D. Add the following parameter to the connection string： Integrated Security=true；
相关考题
-
单项选择题
You work as an application developer at Contoso.com. You use Microsoft .NET Framework 3.5 and Microsoft ADO.NET to develop an application. You want to make sure that the application is operative to any type of database. What should you do？（）
A. Set the database driver name in the connection string of the application， and then the connection object as follows： DbConnection connection = new OdbcConnection（connectionString）；
B. Create the connection object as follows： DbProviderFactory factoryDbProviderFactories.GetFactory（databaseProviderName）； DbConnection connection =factory.CreateConnection（）；
C. Create the connection object as follows： DbProviderFactory factory = DbProviderFactories.GetFactory（"System.Data.Odbc"）； DbConnection connection = factory.CreateConnection（）；
D. Set the database driver name in the connection string of the application， and then the connection object as follows：DbConnection connection = new OleDbConnection（connectionString）； -
单项选择题
You work as an application developer at Contoso.com. You use Microsoft .NET Framework 3.5 and Microsoft ADO.NET to develop an application. The database on the Microsoft SQL Server 2005 database has two tables that are displayed by using two SqlConnection objects in two different GridView controls. You want the tables to be displayed at the same time with the use a single SqlConnection object. What should you do？（）
A. Create a bound connection by using the sp_getbindtoken and the sp_bindsession stored procedures.
B. Enable Multiple Active Result Sets （MARS） in the connection string of the application.
C. Create an exception handler for the connection-busy exception that is thrown on using a single SqlConnection object.
D. Run the two SqlDataReader objects by using a single SqlCommand object. -
多项选择题
You work as an application developer at Contoso.com. You use Microsoft .NET Framework 3.5 and Microsoft ADO.NET to develop an application. You have completed the following code segment. （Line numbers are for reference only.） 01 private void GetRecords（SqlDataAdapter da， DataTable table） { 02 03 try { 04 da.Fill（table）； 05 } 06 catch （SqlException exp） { 08 } 09 finally { 10 11 } 12 } 13 You have set the da.SelectCommand.CommandText property to a stored procedure， which declares a variable named @msg. If the stored procedure has a bad shipping address， it will do the following： 1. sets @msg with the id of the record. 2. raises an error for the record. The raised error can be seen in the following text： RaiseError（@msg， 10， 1）. You want to retrieve all records， valid or not； and that a list item is added to the lstResults list box for each invalid record. What should you do？（）
A.A
B.B
C.C
D.D
E.E
F.F
