TestKing.comusesSQLServer2005.Auserreportsthatanorderprocessingapplicationstoppedrespondinginthemiddleofanordertransaction.TheusersSQLServersessionIDis54.Youneedtofindoutifsession54isblockedbyanotherconnection.Ifitis,youneedtoidentifytheblockingsessionID.Whataretwopossiblewaystoachievethisgoal？（）A.InSQLServerManagementStudio，opentheActivityMonitor.OpentheProcessInfopage.ViewtheblockedBycolumnforsession54.B.InSQLServerManagementStudio，opentheActivityMonitor.OpentheLocksbyProcesspage.ViewtheRequestModecolumnforsession54.C.InSQLServerManagementStudio，openanewquerywindowandexecutethefollowingstatement.SELECT*FROMsys.dmexecrequestsWHEREsessionid=54Viewtheblockingsessionidcolumn.D.InSQLServerManagementStudio，openanewquerywindowandexecutethefollowingstatement.SELECT*FROMsys.dmexecsessionsWHEREsessionid=54Viewthestatuscolumn.

TestKing.comusesSQLServer2005.Auserreportsthatanorderprocessingapplicationstoppedrespondinginthemiddleofanordertransaction.TheusersSQLServersessionIDis54.Youneedtofindoutifsession54isblockedbyanotherconnection.Ifitis,youneedtoidentifytheblockingsessionID.Whataretwopossiblewaystoachievethisgoal？（）

A.InSQLServerManagementStudio，opentheActivityMonitor.OpentheProcessInfopage.ViewtheblockedBycolumnforsession54.

B.InSQLServerManagementStudio，opentheActivityMonitor.OpentheLocksbyProcesspage.ViewtheRequestModecolumnforsession54.

C.InSQLServerManagementStudio，openanewquerywindowandexecutethefollowingstatement.SELECT*FROMsys.dmexecrequestsWHEREsessionid=54Viewtheblockingsessionidcolumn.

D.InSQLServerManagementStudio，openanewquerywindowandexecutethefollowingstatement.SELECT*FROMsys.dmexecsessionsWHEREsessionid=54Viewthestatuscolumn.

相关考题：

() the gab is turned off and the door is locked before you leave home. A、It’s sure thatB、Make sure thatC、Certain thatD、I certain that
查看答案
在油田化学剂中,重晶石粉在钻井液中主要起()作用。 A、造浆B、降粘C、增粘D、加重
查看答案
可以设置html表单元素非空不允许提交的属性是()。 A.requiredB.requestC.requireD.requires
查看答案
思想政治课是德育的主要途径。()
查看答案
Onthedevelopmentdatabaserac0，therearesixrawdevices：/dev/raw/raw1through/dev/raw/raw6./dev/raw/raw1and/dev/raw/raw2are8GBeach，andtherestare6GBeach.Anexistingdiskgroup+DATA1，ofNORMALREDUNDANCY，uses/dev/raw/raw1and/dev/raw/raw2.Whichseriesofthefollowingcommandswilldroponeofthefailuregroupsfor+DATA1，createanewdiskgroup+DATA2usingtwooftheremainingfourrawdevices，andthencancelthedropoperationfrom+DATA1？（）A.AB.BC.CD.D
查看答案
以下Motorola的切换算法中,优先级最低的是:()。 A.上下行质量（ul_rxqual，dl_rxqual，还有包括干扰切换）B.上下行电平（ul_rxlev，dl_rxlev）C.距离切换（TA）D.功率预算切换（PBGT）
查看答案
以下编码率最高的语音编码方式为()。 A.PCMB.ADPCMC.CELPD.AMBE
查看答案
华为BTS3900基站设备中,下面关于HCPM单板描述正确的是()。 A.前向256CE，反向192CEB.使用一片Qualcomm CSM6800芯片C.一个BBU3900中最多配置6块HCPM单板D.是1X信道处理板
查看答案
热门标签