多做题,通过考试没问题!

微软认证考试

睦霖题库>其他计算机考试>微软认证考试

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
答案解析:
进入题库查看解析

微信扫一扫手机做题