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
Explanation:tempdb is used to store the sort runs, and sufficient free space in the destination filegroup to store the final index structure. 6. Which of the following query disables all the indexes on Employee table ?