HP
HP2-N36 · Question #30
What are the disadvantages of using delete vectors to identify records marked for deletion? (Select two.)
The correct answer is C. Delete vectors must be recognized during the query process to remove records marked for D. Delete vectors do not instantly reclaim space used by deleted records. See the full explanation below for the reasoning.
Question
What are the disadvantages of using delete vectors to identify records marked for deletion? (Select two.)
Options
- ADelete vectors are stored in a different location, minimizing storage impact.
- BDelete vectors rewrites files, causing additional overhead.
- CDelete vectors must be recognized during the query process to remove records marked for
- DDelete vectors do not instantly reclaim space used by deleted records.
- EDelete vectors must be maintained forever.
How the community answered
(40 responses)- A10% (4)
- B5% (2)
- C70% (28)
- E15% (6)
Community Discussion
No community discussion yet for this question.