单项选择题

YouworkinacompanywhichusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instancewhichcontainsadatabase.NowyourcompanyCIOassignsatasktoyou.YouhavetochecktheperformanceoftheSQLServer2008instance.Youhavetofindoutwhichcommonlanguageruntime(CLR)queriestakesthelongest-runningtime.Sointheoptionsbelow,whichdynamicmanagementviewshouldyouchoosetouse?（）
A.sys.dm_os_wait_stats
B.sys.dm_exec_requests
C.sys.dm_exec_sessions
D.sys.dm_exec_query_stats

A.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instancewhichcontainsadatabase.NowyourcompanyCIOassignsatasktoyou.YouhavetochecktheperformanceoftheSQLServer2008instance.Youhavetofindoutwhichcommonlanguageruntime(CLR)queriestakesthelongest-runningtime.Sointheoptionsbelow,whichdynamicmanagementviewshouldyouchoosetouse?（）
A.sys.dm_os_wait_stats
B.sys.dm_exec_requests
C.sys.dm_exec_sessions
D.sys.dm_exec_query_stats

你可能感兴趣的试题

单项选择题

Youhavealogin.ascxcontrolandtodisplayitinaviewwhichmethoduwoulduse（）

A.http.display
B.http.partial
C.http.load
D.http.get

单项选择题

YouworkinacompanywhichusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.ThereisadatabasenamedDB1intheinstance.IntheServicesschema，ThereisatablenamedService.Table.TheServices.TablehastobemovedfromtheSalesschematoanewschemanamedCosts.Intheoptionsbelow，whichTransact-SQLstatementshouldyouexecute？（）
A.ALTERTABLEService.TableSWITCHTOCosts.Table1;
B.ALTERSCHEMACostsTRANSFERService.Table;
C.ALTERUSERServiceWITHDEFAULT_SCHEMA=Costs;
D.ALTERAUTHORIZATIONONService.Table1TOCosts;

A.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.ThereisadatabasenamedDB1intheinstance.IntheServicesschema，ThereisatablenamedService.Table.TheServices.TablehastobemovedfromtheSalesschematoanewschemanamedCosts.Intheoptionsbelow，whichTransact-SQLstatementshouldyouexecute？（）
A.ALTERTABLEService.TableSWITCHTOCosts.Table1;
B.ALTERSCHEMACostsTRANSFERService.Table;
C.ALTERUSERServiceWITHDEFAULT_SCHEMA=Costs;
D.ALTERAUTHORIZATIONONService.Table1TOCosts;