You have a database named DB1 that contains a table named Tabie1. Table1 has a non-clustered index named index1.
You discover that index1 is corrupt.
You need to repair index1.
Which statement should you execute?
A . ALTER INDEX index1 ON table1 REBUILD WITH (ONLINE=0N)
B . DBCC CHECKOB (‘db1*, TABLOCK)
C . DBCC CHECKDB (*db1, REPAIR_FAST)
D . DROP INDEX index1 ON tabie1
Answer: A
Explanation:
If REBUILD is performed online (ON) the data in this table is available for queries and data modification during the index operation.
References:
https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-index-transact-sql?view=sql-server-2017
https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-checkdb-transact-sql?view=sqlserver-
2017