多項(xiàng)選擇題

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.

你可能感興趣的試題

單項(xiàng)選擇題

You create a Web Form. The Web Form uses the FormView control to enable a user to edit a record in the database. When the user clicks the Update button on the FormView control, the application must validate that the user has entered data in all of the fields. You need to ensure that the Web Form does not update if the user has not entered data in all of the fields. Which code segment should you use? （）

A.protectedvoidFormView1_ItemUpdating（objectsender，F(xiàn)ormViewUpdateEventArgse）{foreach（DictionaryEntryentryine.Keys）{if（entry.Value.ToString（）==System.String.Empty）{e.Cancel=true；return；}}}
B.protectedvoidFormView1_ItemUpdated（objectsender，F(xiàn)ormViewUpdateEventArgse）{foreach（DictionaryEntryentryine.NewKeys）{if（entry.Value.Equals（“”））{e.KeepEditMode=true；return；}}}
C.protectedvoidFormView1_ItemUpdating（objectsender，F(xiàn)ormViewUpdateEventArgse）{foreach（DictionaryEntryentryine.NewValues）{if（entry.Value.Equals（“”））{e.Cancel=true；return；}}}
D.protectedvoidFormView1_ItemUpdating（objectsender，F(xiàn)ormViewUpdateEventArgse）{foreach（DictionaryEntryentryine.Keys）{if（entry.Value.ToString（）==System.String.Empty）{e.KeepInEditMode=true；return；}}}

單項(xiàng)選擇題

You have an SQL query that takes one minute to execute. You use the following code segment to execute the SQL query asynchronously.IAsyncResult ar = cmd.BeginExecuteReader();You need to execute a method named Do Work() that takes one second to run while the SQL query is executing. DoWork() must run as many times as possible while the SQL query is executing. Which code segment should you use? （）

A.while（ar.AsyncWaitHandle==null）{DoWork（）；}dr=cmd.EndExecuteReader（ar）；
B.while（!ar.IsCompleted）{DoWork（）；}dr=cmd.EndExecuteReader（ar）；
C.while（Thread.CurrentThread.ThreadState==ThreadState.Running）{DoWork（）；}dr=cmd.EndExecuteReader（ar）；
D.while（!ar.AsyncWaitHandle.WaitOne（））{DoWork（）；}dr=cmd.EndExecuteReader（ar）；

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美 国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

你可能感興趣的試題

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线