用来帮助用户维护索引的工具有（ ） A: UPDATE STATISTICS语句 B: DBCC SHOWCONTIG语句 C: DBCC INDEXDEFRAG语句 D: 以上都是

恢复数据库使用( )语句。 A: BACKUP B: RESTORE C: SHRINK D: DBCC

创建数据库使用( )命令。 A: create database B: alter database C: drop database D: dbcc shinkdatabase

You are a database administrator for your company. You are responsible for a SQL Server 2005 database that has several indexes. You need to write a stored procedure that checks the indexes for fragmentation. Which Transact-SQL statement should you use？（） A: DBCC DBREINDEX B: SELECT * FROM sys.dm_db_index_physical_stats C: DBCC INDEXDEFRAG D: SELECT * FROM sys.indexe

You are a database administrator for your company. You are responsible for a SQL Server 2005 database that has several indexes. You need to write a stored procedure that checks the indexes for fragmentation. Which Transact-SQL statement should you use？（） A: DBCC DBREINDEX B: SELECT * FROM sys.dm_db_index_physical_stats C: DBCC INDEXDEFRAG D: SELECT * FROM sys.indexes