Neco 2022 Data Processing Question 1

Practice objective / multiple choice question 1 from the 2022 Neco Data Processing examination.

Neco 2022 Data Processing Objective / Multiple Choice Medium Difficulty
Question 1 NECO • 2022 • DATA_PROCESSING • objective

A company maintains 10,000 employee records, each occupying 150 bytes. To support fast retrieval by employee ID and also to generate reports sorted by department, the company considers three file organisations: 1. Sequential file (no index). 2. Indexed sequential file with a primary index on employee ID. The block size is \(512\) bytes and each index entry occupies \(12\) bytes. 3. Direct (hash) file with 2,000 buckets. Assuming the data occupy the same amount of storage in all three cases, which file organisation provides the minimum total storage (data plus index) while satisfying both the fast‑ID retrieval and the sorted‑by‑department reporting requirements?

Answer Options

A. Direct
B. Hybrid
Correct Answer C. Indexed sequential
D. Sequential
Correct Answer
C
Correct Option:
Indexed sequential

About This Question

This is Neco 2022 Data Processing Question 1. It is one of the objective questions from the 2022 Neco Data Processing examination.

Difficulty level: Medium .

Master the Exam!

You've seen a preview, but there are thousands more questions plus AI tutor to break down complex solutions.

Unlock Full Access Available for Android & Windows
Chat with Support