Neco 2021 Data Processing Question 47
Practice objective / multiple choice question 47 from the 2021 Neco Data Processing examination.
A database file contains 2,000 records. Three file‑organization methods are used with the following probabilities of access: sequential 0.5, indexed 0.3, direct 0.2.\n\n• Sequential access scans, on average, half the file; each record read takes 0.02 ms.\n• Indexed access uses a two‑level primary index; each index level costs 0.05 ms and the final data block costs 0.02 ms.\n• Direct access uses hashing with an average of 1.5 probes; each probe costs 0.03 ms.\n\nCalculate the overall average record‑access time (in milliseconds) for the file.
Answer Options
About This Question
This is Neco 2021 Data Processing Question 47. It is one of the objective questions from the 2021 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.