ITPEC FE Morning April 2019 Question 30
ITPEC FE Morning April 2019 — Question 30 of 80
Database Reorganization — periodic maintenance to prevent degradation of access efficiency.
Over time, databases accumulate fragmentation from inserts, updates, and deletes. Reorganization reclaims unused space and restores optimal data layout.
Why not others:
- (a) Backup — creates a copy for recovery, not for performance
- (b) Database dump — exports data (a form of backup)
- (d) Roll back — reverts a transaction to a previous state
Key rule: "Periodically executed to prevent reducing access efficiency" = Reorganization (defragmentation of database storage).
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.