用来帮助用户维护索引的工具有（ ）
A: UPDATE STATISTICS语句
B: DBCC SHOWCONTIG语句
C: DBCC INDEXDEFRAG语句
D: 以上都是
A: UPDATE STATISTICS语句
B: DBCC SHOWCONTIG语句
C: DBCC INDEXDEFRAG语句
D: 以上都是
举一反三
- 恢复数据库使用( )语句。 A: BACKUP B: RESTORE C: SHRINK D: DBCC
- 下面哪一个语句可以使用子查询（） A: SELECT 语句 B: UPDATE语句 C: DELETE语句 D: 以上都是
- 下列选项中,可以用来删除表中部分数据的语句是() A: DELETE语句 B: INSERT语句 C: UPDATE DELETE语句 D: DROP语句
- 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