Database Administrator (DBA) Question:

Download Job Interview Questions and Answers PDF

How can you rebuild an index?

Database Administrator (DBA) Interview Question
Database Administrator (DBA) Interview Question

Answer:

ALTER INDEX <index_name> REBUILD;.

Download Database Administrator (DBA) Interview Questions And Answers PDF

Previous QuestionNext Question
How would you determine who has added a row to a table?Explain what partitioning is and what its benefit is.