Gce Model Questions Vol1 2025 Computer Studies Question 21
Practice objective / multiple choice question 21 from the 2025 Gce Model Questions Vol1 Computer Studies examination.
A database contains three tables. Table A has 150\,000 records with an average record size of 120\,bytes, Table B has 80\,000 records with an average size of 200\,bytes, and Table C has 50\,000 records with an average size of 350\,bytes. A new indexing scheme reduces the average record size of Tables A and B by 12\% but increases the average size of Table C by 5\% because of additional index overhead. What is the overall percentage change in the total size of the database after applying the scheme? Give your answer to one decimal place and state whether it is an increase or a reduction.
Answer Options
About This Question
This is Gce Model Questions Vol1 2025 Computer Studies Question 21. It is one of the objective questions from the 2025 Gce Model Questions Vol1 Computer Studies 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.