多项选择题
You are developing an application that connects to a Microsoft SQL Server database using the SqlConnection object. Your connection objects are being pooled. As the pool fills up, connection requests are queued. Some connection requests are rejected. You need to ensure that the application releases connections back to the pool as soon as possible. Also, you need to decrease the likelihood that connection requests will be rejected. Which three actions should you perform?（）
A. Ensure that the Close method is called on each connection object after it has finished executing.
B. Ensure that each connection object is left open after it has finished executing.
C. Increase the Max Pool Size value inside the connection string.
D. Increase the Min Pool Size value inside the connection string.
E. Increase the Connection Lifetime value inside the connection string.
F. Increase the value of the ConnectionTimeout property of the SqlConnection object.
相关考题
-
多项选择题
You create a Web Form that contains a TreeView control. The TreeView control allows users to navigate within the Marketing section of your Web site. The following XML defines the site map for your site. You need to bind the TreeView control to the site map data so that users can navigate only within the Marketing section. Which three actions should you perform?（）
A. Add a SiteMapDataSource control to the Web Form and bind the TreeView control to it.
B. Add a SiteMapPath control to the Web Form and bind the TreeView control to it.
C. Embed the site map XML within the SiteMap node of a Web.sitemap file.
D. Embed the site map XML within the AppSettings node of a Web.config file.
E. Set the StartingNodeUrl property of the SiteMapDataSource control to ~/Marketing.aspx.
F. Set the SkipLinkText property of the SiteMapPath control to Sales. -
单项选择题
You are creating a Web Form. The Web Form allows users to rename or delete products in a list. You create a DataTable named dtProducts that is bound to a GridView. DataTable has the following four rows. dtProducts. Rows(0)("ProductName") = "Soap"dtProducts. Rows(1)("ProductName") = "Book"dtProducts. Rows(2)("ProductName") = "Computer"dtProducts. Rows(3)("ProductName") = "Spoon"dtProducts. AcceptChanges() The user utilizes a Web Form to delete the first product. You need to set the RowStateFilter property of the DataTables DefaultView so that only products that have not been deleted are shown. To which value should you set the DataTabless DefaultView.RowStateFilter?（）
A. Data View Row State.Modified Original
B. Data View Row State.Modified Current
C. Data View Row State.Current Rows
D. Data View Row State.Added -
单项选择题
You are transferring records from one database to another. You need to decide whether you can use the SqlBulkCopy class to transfer the records. What should you do? （）
A. Ensure that the source database is Microsoft SQL Server.
B. Ensure that the destination database is Microsoft SQL Server.
C. Ensure that the column names in the source table match the column names in the destination table.
D. Ensure that the bulk copy program (bcp) utility is installed on the destination server.
