Multiple choice technology databases

Which two statements are true about rebuilding an index?

  1. The resulting index may contain deleted entries.

  2. A new index is built using an existing index as the data source.

  3. Queries cannot use the existing index while the new index is being built.

  4. During a rebuild, sufficient space is needed to accommodate both the old and the new
Reveal answer Fill a bubble to check yourself
B,D Correct answer
Explanation

Rebuilding an index creates a new index using the existing index as the data source, requiring sufficient temporary disk space to hold both the old and new indexes simultaneously. The new index will not contain deleted entries, and online rebuilds allow concurrent queries.

Keep practicing — related questions