试题详情
单项选择题 Your database is 5GB and contain satable named Sales History. Sales informationis frequently inserted and updated. You discover that excessive page splitting is occurring. You need to reduce the occurr enceof page splitting in the Sales History table. Which code segment should you use?（）

A、ALTER DATABASE Sales  MODIFY FILE(NAME = Sales dat3, SIZE = 10GB)

B、ALTER INDEXALL ON Sales.Sales History REBUILD WITH (FILLFACTOR = 60)

C、EXEC sys.sp_configure 'fill factor (%)', '60'

D、UPDATE STATISTICS Sales.Sales History(Products)  WITH FULLSCAN, NORECOMPUTE

  • B

  • 关注下方微信公众号，在线模考后查看

热门试题