ITPEC FE Morning April 2021 Question 26
ITPEC FE Morning April 2021 — Question 26 of 80
Database Reorganization — periodic maintenance to prevent access efficiency decline.
Over time, databases accumulate fragmentation from inserts, updates, and deletes — data becomes scattered and gaps appear in storage.
Reorganization periodically restructures the physical storage:
- Eliminates fragmentation and reclaims wasted space
- Rebuilds indexes for faster lookups
- Restores optimal access performance
Why not others:
- (a) Backup — creates a copy for disaster recovery, not for performance
- (b) Database dump — exports data to a file, a form of backup
- (d) Rollback — reverts a transaction to a previous state, not periodic maintenance
Key rule: When the question says "periodically" + "access efficiency" → Reorganization.
AI-generated — may contain errors
The original exam layout is preserved in the image so diagrams, formulas, tables, and code remain accurate.
This question comes from an official ITPEC past paper. ITPEC Practice is an independent study tool and is not affiliated with ITPEC. See the official FE past-paper collection or Report an issue.