Which statement should you execute?

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

View Answer

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