Your database is5GB and contain satablenamed Sales History.Salesinformationisfrequentlyinsertedandupdated.Youdiscoverthatexcessivepagesplittingisoccurring.Youneed toreducetheoccurr enceofpagesplittinginthe Sales History table.Whichcodesegmentshouldyou use?()
A.ALTERDATABASESalesMODIFYFILE(NAME=Sales dat3,SIZE=10GB)
B.ALTERINDEXALLONSales.Sales HistoryREBUILDWITH(FILLFACTOR=60)
C.EXECsys.sp_configure‘fillfactor(%)‘,‘60‘
D.UPDATESTATISTICSSales.Sales History(Products)WITHFULLSCAN,NORECOMPUTE
参考答案:B