Explanation:DBCC DBREINDEX can enable all indexes for a table in the specified database. 5. Point out the wrong statement :
A. If SORT_IN_TEMPDB is set to OFF, the free space in the destination filegroup must be large enough to store the final index structure.
B. When you create a clustered index on a table that has nonclustered indexes, you must have available as free space
C. When you set the SORT_IN_TEMPDB option to ON, you must have sufficient free disk space available in master database
D. All of the mentioned
Answer:A
Explanation:DBCC DBREINDEX can enable all indexes for a table in the specified database. 5. Point out the wrong statement :
A. If SORT_IN_TEMPDB is set to OFF, the free space in the destination filegroup must be large enough to store the final index structure. B. When you create a clustered index on a table that has nonclustered indexes, you must have available as free space C. When you set the SORT_IN_TEMPDB option to ON, you must have sufficient free disk space available in master database D. All of the mentioned