Difficulty: Medium
Correct Answer: is a measure of the percentage of existing records updated during a run
Explanation:
Introduction / Context: Traditional batch systems track file “activity” to estimate processing effort and choose suitable organizations (sequential, indexed, hashed). Understanding file activity helps in planning runtimes, optimizing I/O, and deciding when to reorganize or index files for performance.
Given Data / Assumptions:
Concept / Approach: File activity commonly denotes the proportion of existing records that are updated (changed) during a processing run. A high activity level suggests many in-place updates and possibly insertions/deletions, which can degrade efficiency for certain organizations (for example, purely sequential files), prompting the use of indexed access or reorganization strategies. While high activity can reduce efficiency (option b describes an effect), the definition itself is the percentage updated measure (option c).
Step-by-Step Solution:
Define the term: activity = percent of existing records updated this run.Relate implications: higher activity may suggest different file organizations.Choose the option that gives the definition, not an effect or unrelated idea.Verification / Alternative check: Systems analysis texts define activity in terms of update frequency; engineering estimates of I/O cost often consider this percentage when selecting access methods.
Why Other Options Are Wrong:
Low percentage of adds/deletes: that is a different concept (churn), not the standard definition of activity.If high, reduces efficiency: consequence, not definition.How closely the file fits allocation: relates to storage utilization, not activity.None: incorrect because option (c) provides the accepted definition.Common Pitfalls: Confusing updates with adds/deletes; or using the consequences of high activity as the definition itself. Keep definition and effects separate for proper analysis.
Final Answer: is a measure of the percentage of existing records updated during a run
Discussion & Comments