Neco 2017 Data Processing Question 9

Practice objective / multiple choice question 9 from the 2017 Neco Data Processing examination.

Neco 2017 Data Processing Objective / Multiple Choice Medium Difficulty
Question 9 NECO • 2017 • DATA_PROCESSING • objective

A school keeps a student file containing the fields Admission No (unique), Name, Class and Scores. The following operations are frequently performed: (i) retrieve a student's full record when the Admission No is known, (ii) list all students in a given Class sorted alphabetically by Name, (iii) update a student's Scores. For each operation, recommend the most suitable type of file organization (Sequential, Indexed Sequential, Direct/Random) and briefly justify your choice.

Answer Options

A. (i) Indexed sequential file using Admission No as key; (ii) Sequential file sorted by Class then Name; (iii) Sequential file for updates
B. (i) Direct (random) access file using Name as key; (ii) Indexed sequential file organised by Scores then Name; (iii) Direct (random) access file using Class for updates
Correct Answer C. (i) Direct (random) access file using Admission No as key; (ii) Indexed sequential file organised by Class then Name; (iii) Direct (random) access file for updates
D. (i) Sequential file using Admission No; (ii) Direct (random) access file organised by Class then Name; (iii) Indexed sequential file for updates
Correct Answer
C
Correct Option:
(i) Direct (random) access file using Admission No as key; (ii) Indexed sequential file organised by Class then Name; (iii) Direct (random) access file for updates

About This Question

This is Neco 2017 Data Processing Question 9. It is one of the objective questions from the 2017 Neco Data Processing examination.

Difficulty level: Medium .

View More Neco 2017 Data Processing Questions More Neco Practice Questions Back to Questions

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