Neco 2024 Data Processing Question 23
Practice objective / multiple choice question 23 from the 2024 Neco Data Processing examination.
A database uses three file‑organization methods. For a particular query the probabilities of accessing a record via each method are: Sequential 0.5, Indexed‑Sequential 0.3, Direct 0.2. Their average access times are 8 ms, 5 ms and 2 ms respectively. (a) Compute the expected access time for the query. (b) If a new indexing scheme reduces the Indexed‑Sequential access time by 20 % (i.e. to 4 ms) while the other times stay unchanged, what is the new expected access time? Give both results in milliseconds.
Answer Options
About This Question
This is Neco 2024 Data Processing Question 23. It is one of the objective questions from the 2024 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.