可学答题网 > 问答 > MCTS(70-432)题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

You work in a com


You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named named Dworks in the instance. The Dworks database has a table named Bills which contains several indexes and a great amount of rows. An enterprise Web environment is supported by the database. Onthe Bills table 28% of the indexes have been fragmented. You have to defragment the indexes, making sure that you reduce the effect on database availability to the least.  In the ALTER INDEX statement, which option should be included?()

  • ASort in tempdb 
  • BOnline 
  • CFill factor 
  • DPad index&e
参考答案
参考解析:
分类:MCTS(70-432)题库
相关推荐

1、You work in a com

You work in a company which uses SQL Server 2008. You are the administrator of the co...

2、You work in a com

You work in a company which uses SQL Server 2008. You are the administrator of the co...

3、You work in a com

You work in a company which uses SQL Server 2008. You are the administrator of the co...

4、You work in a com

You work in a company which uses SQL Server 2008. You are the administrator of the co...

5、You work in a com

You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. ...

6、You work in a com

You work in a company which uses SQL Server 2008. You are the administrator of the co...