网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)

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 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. ” 相关考题
考题 --Must we finish our homework now? --No, you ______. You _______ finish it after school. A.needn't , mayB.mustn't , mayC.can't , canD.needn't , must

考题 用T2000DM工具备份的MO存放的目录可以任意选择,而用网管界面上的“数据库备份”备份后的MO只能存放在:() A./T2000/server/database/MOB./T2000/server/scriptC./T2000/server/database/dbbackup

考题 下列连接字符实现与SQL Server数据库的连接,( )是不正确的。A.Driver={SQL Server}; Server=localhost; Database=stuDB; Uid=; Pwd=;B.Provider=SQLOLEDB; Data Source=localhost; Database=stuDB; Uid=abc; Pwd=12;C.Data Source=.\\SQLEXPRESS; Database=SchoolDB; Uid=abc; Pwd=;D.Driver={SQL Server 2000}; Server=localhost; Database=stuDB; Uid=abc; Pwd=123;

考题 下面是该网站中数据库连接程序conn.inc的代码,请在空白处填入相应的程序代码。<%Setcorm=server.(1)("adodb.connection")conn.provider="sqloledb"provstr="server=127.0.0.1;database=(2);uid=(3);pwd=(4)"conn.open(5)%>

考题 YouaretheadministratorofaMicrosoftWindowsServer2003computernamedServer1.SQLServer2005isinstalledonServer1tohostadatabasenamedMedDB.TheMedDBdatabaseservesasthebackenddatabaseforanewclient/serverapplicationnamedMedDATA.InstallationoftheMedDATAapplicationcreatesthedatabaseschema,applicationroles,andadministrativeaccounts.Italsosetsallofthedefaultpermissions.YouneedtoestablishapermissionsbaselineforallobjectsintheMedDBdatabase.Whatshouldyoudo?()A.UsetheSQLServer2005ManagementStudiotoreviewthepermissionsofthedefaultdatabaseobjects.B.Querythesys.server_permissionstableonServer1.C.Executethesp_helploginssystemstoredprocedureforeachofthedefaultusersthattheMedDATAapplicationcreates.D.Querythesys.database_permissionsandsys.database_principalstablesintheMedDBdatabase.

考题 YouhaveanExchangeorganization.TheExchangeserversintheorganizationareconfiguredasshowninthefollowingtable.YoudeployanewExchangeServer2010ClientAccessservernamedServer4andsuccessfullyupdatetherequiredDNSrecordsforServer4.YouneedtoensurethatallusersonServer3cansuccessfullyaccesstheirmailboxesbyusingExchangeActiveSync.Whatshouldyoudo()?A.OnServer1,settheauthenticationtypefortheMicrosoft-Server-ActiveSyncvirtualdirectorytonTLm.B.OnServer1,settheauthenticationtypefortheMicrosoft-Server-ActiveSyncvirtualdirectorytoanonymous.C.FromtheExchangeManagementShellonServer4,runNew-ActiveSyncDeviceAccessRulequeryString*-CharacteristicDeviceModelAccessLevelAllow.D.FromtheExchangeManagementShellonServer3,runSet-ActiveSyncVirtualDirectory-Identityserver3\Microsoft-Server-ActiveSync(defaultwebsite)-Basicauthentication:$true.

考题 YouhaveanExchangeServer2010organizationnamedcontoso.com.YouhaveaClientAccessservernamedcas1.contoso.comthatisaccessibleontheInternet.Youaccesscas1.contoso.comontheInternetbyusingthefollowingdomainnames:(1)mail.contoso.com(2)autodiscover.contoso.comYouneedtoensurethatmobiledevicescanuseAutodiscoverontheInternet.Whatshouldyoudo?()A.SettheexternalURLforMicrosoft-Server-ActiveSyncto$NULL.B.SettheexternalURLforMicrosoft-Server-ActiveSynctohttps://cas1.contoso.com/MicrosoftServerActiveSync.C.SettheexternalURLforMicrosoft-Server-ActiveSynctohttps://mail.contoso.com/Microsoft-Server-ActiveSync.D.SettheexternalURLforMicrosoft-Server-ActiveSynctohttp://autodiscover.contoso.com/Microsoft-Server-ActiveSync.

考题 下列连接字符实现与SQL Server数据库的连接,()是不正确的A.Driver={SQL Server}; Server=localhost; Database=stuDB; Uid=; Pwd=;B.Provider=SQLOLEDB; Data Source=localhost; Database=stuDB; Uid=abc; Pwd=12;C.Data Source=.SQLEXPRESS; Database=SchoolDB;Uid=abc; Pwd=;D.Driver={SQL Server 2000}; Server=localhost; Database =stuDB; Uid=abc; Pwd=123;

考题 下列连接字符实现与SQL Server数据库的连接,()是不正确的。A.Driver={SQL Server}; Server=localhost; Database=stuDB; Uid=; Pwd=;B.Provider=SQLOLEDB; Data Source=localhost; Database=stuDB; Uid=abc; Pwd=12;C.Data Source=.SQLEXPRESS; Database=SchoolDB;Uid=abc; Pwd=;D.Driver={SQL Server 2000}; Server=localhost; Database =stuDB; Uid=abc; Pwd=123;

考题 19、下列连接字符实现与SQL Server数据库的连接,()是不正确的。A.Driver={SQL Server}; Server=localhost; Database=stuDB; Uid=; Pwd=;B.Provider=SQLOLEDB; Data Source=localhost; Database=stuDB; Uid=abc; Pwd=12;C.Data Source=.\\SQLEXPRESS; Database=SchoolDB;Uid=abc; Pwd=;D.Driver={SQL Server 2000}; Server=localhost; Database =stuDB; Uid=abc; Pwd=123;