多项选择题
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 then define the connection string of the application as follows:
"Server=Prod;Database=WingtipToys;Integrated Security=SSPI;Asynchronous Processing=true"
The following code segment is used on the application: (Line numbers are included for reference only.)
01 protected void UpdateData(SqlCommand cmd) {
02 cmd.Connection.Open();
03
04 lblResult.Text = "Updating ...";
05 }
You discover that the cmd object takes a long time to execute. You want to make sure that the application continues to execute while cmd is executing.
What should you do?()
A.A
B.B
C.C
D.D
E.E
F.F
G.G
相关考题
-
单项选择题
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. Create an exception handler for the connection-busy exception that is thrown on using a single SqlConnection object.
C. Run the two SqlDataReader objects by using a single SqlCommand object.
D. Enable Multiple Active Result Sets (MARS) in the connection string of the application. -
单项选择题
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 user name and password that is kept by the connection string is stored directly in the code of the application. You want to make sure that the password in the connection string is as protected. What should you do? ()
A. Add the connection string to the Settings.settings file.
B. Add connection string to the Web.config file and use protected configuration.
C. Use the TRUE setting in the Persist Security Info keyword.
D. Use the FALSE setting in the Persist Security Info keyword -
单项选择题
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. The application uses an XML file that contains product data. Furthermore, a corresponding XSD file contains the schema of the XML file. You want the application to do the following: Loads the XML file in a typed DataSet and validates it against the schema provided in the XSD file. What should you do? ()
A.A
B.B
C.C
D.D
