Question

There are ________ options for compacting a database?

1) two
2) three
3) four
4) five

Answer 1

The correct answer is 2) three. There are three options for compacting a database: deletion of unused space, defragmentation, and index rebuilding.

Step-by-step explanation:

The correct answer is 2) three.

When it comes to compacting a database, there are three options:

1. Deletion of Unused Space: This option removes any empty or unused space from the database, making it more efficient.
2. Defragmentation: Defragmenting a database rearranges the data and reduces fragmentation, which can improve performance.
3. Index Rebuilding: Rebuilding indexes can help optimize query performance by ensuring they are properly organized.