Purpose of DBCC DBREINDEX command is to :
A. Rebuilds one or more indexes for a table in the specified database.
B. Rebuilds only one index for a table in the specified database.
C. Displays fragmentation information for the data and indexes of the specified table.
D. All of the mentioned
Answer:A
Purpose of DBCC DBREINDEX command is to :
A. Rebuilds one or more indexes for a table in the specified database. B. Rebuilds only one index for a table in the specified database. C. Displays fragmentation information for the data and indexes of the specified table. D. All of the mentioned
Explanation:The DBCC DBREINDEX command will not automatically rebuild all of the indexes on all the tables in a database; it can only work on one table at a time.