Skip to content
HeadTeacher.ng
Examinations

First Term Data Processing Examination for SS 3

First Term Data Processing Examination for SS 3. This SS 3 lesson follows the scheme of work.

Published Reading13 min Comments0

Class: SSS 3
Term: First Term
Subject: Data Processing
Time: 2 Hours 30 Minutes
Total Marks: 70


SECTION A: OBJECTIVES (40 Marks)
Instruction: Answer ALL 40 questions. Each question carries 1 mark.

  1. Which of the following best describes a distributed DBMS? (a) A single paper register kept in the principal’s office    (b) A system managing logically related data stored across networked sites    (c) A program with no data communication between sites    (d) A printer attached directly to one computer
  2. The ________ of an unfamiliar background process and repeated unexpected pop-ups is a reason to investigate malware. (a) appearance    (b) compression ratio    (c) index cardinality    (d) normalised relation
  3. A program that attaches malicious code to other files and spreads when infected programs execute is best described as ________. (a) a database primary index    (b) a write-ahead log    (c) a computer virus    (d) a network switch
  4. The main reason to schedule verified backups during software maintenance is to ________. (a) replace the need to patch vulnerable programs    (b) retain a recoverable copy if updates or failures damage data    (c) ensure viruses cannot enter any network    (d) make a damaged disk physically stronger
  5. An unexplained surge in corrupted files and unfamiliar programs suggests ________. (a) proof that a LAN has become a WAN    (b) that secondary indexes have been removed deliberately    (c) that every stored file is automatically encrypted    (d) a possible malware infection requiring investigation
  6. A computer begins shutting down during heavy use. Which hardware-maintenance check is most relevant first? (a) Delete secondary indexes from an unrelated server    (b) Inspect ventilation and cooling for obstruction or faults    (c) Change all users’ screen wallpapers    (d) Increase the number of database forms
  7. The correct step before dividing a large database task among multiple processors is to ________. (a) remove the transaction rules entirely    (b) assign every task to one processor and disable the rest    (c) delete the query’s search conditions    (d) identify work that can run in parallel while preserving correct results
  8. Which of the following is a typical advantage of a local area network within a school? (a) Guaranteed connectivity to every country without external links    (b) Automatic removal of all malware    (c) Shared access to authorised resources over a limited site    (d) Independence from every networking device
  9. All these are software-maintenance practices except ________. (a) installing approved patches    (b) removing unnecessary software    (c) checking antivirus updates    (d) cleaning dust from a computer’s internal fan
  10. All these are common network topology arrangements except ________. (a) a bus    (b) a primary-secondary database index    (c) a ring    (d) a star
  11. A school has separate regional database sites. A major benefit of distributing the data near users is ________. (a) the elimination of all communication costs    (b) automatic protection from every hardware fault    (c) the removal of the need to coordinate updates    (d) improved local access when the design and links are suitable
  12. A table is most often searched by registration number, a unique identifier. Which of the following is the strongest candidate for a primary-key index? (a) Registration number    (b) Student’s favourite sport    (c) Time of last screen refresh    (d) Printer manufacturer’s name
  13. Which action does NOT improve virus prevention? (a) Keeping security software updated    (b) Installing unknown software from untrusted sources    (c) Restricting suspicious attachments    (d) Maintaining current software patches
  14. A user receives an unsolicited attachment that claims to contain examination scores. The most defensible response is to ________. (a) enable macros immediately to inspect its contents    (b) forward it to every network user    (c) verify the sender and scan the file before opening it    (d) turn off endpoint protection first
  15. The main reason parallel database processing may improve a large analytical query is that ________. (a) a query must run on only one processor    (b) data integrity checks become unnecessary    (c) all computers must have identical user accounts    (d) independent portions of the work can be executed concurrently
  16. A query filters by surname only, but the composite index begins with registration number. The most reasonable judgement is that ________. (a) the index may not efficiently support a surname-only search    (b) every composite index accelerates all possible field combinations    (c) the registration number must be deleted    (d) database access control has failed
  17. The ________ is responsible for coordinating access rules, user privileges and other database-security controls. (a) unverified external visitor    (b) ordinary printer driver    (c) database administrator    (d) spreadsheet chart editor
  18. Which of the following best distinguishes rollback from redo after a crash? (a) Both always erase every database record    (b) Rollback copies network cables; redo replaces printer drivers    (c) Redo is used only to check user passwords    (d) Rollback reverses incomplete work; redo reapplies recorded committed changes
  19. Which of the following identifies a major complication of distributed databases compared with one isolated database? (a) Coordinating transactions across separate sites    (b) Making any table contain more than one column    (c) Allowing data to have a primary key    (d) Displaying a local report
  20. A clerk may view attendance but must not change examination scores. Which control best enforces this? (a) Sharing the head teacher’s administrator password    (b) Removing the login requirement    (c) Role-based permissions with restricted update rights    (d) Granting unrestricted ownership of all tables
  21. A school’s network covers two campuses connected over a substantial distance. Which category is more suitable than a single-room LAN? (a) Wide area network    (b) Personal area network confined to a desk    (c) An internal CPU bus    (d) A database index
  22. The ________ can improve searches on a field that is not the primary ordering key of a data file. (a) display theme    (b) secondary index    (c) recovery partition    (d) printer queue
  23. Which of these is not a purpose of a write-ahead transaction log? (a) Supporting rollback of incomplete work    (b) Supporting recovery of committed changes    (c) Recording actions in an order usable for recovery    (d) Guaranteeing that database information never needs backups
  24. Which action does NOT constitute appropriate hardware maintenance? (a) Checking cooling and ventilation    (b) Inspecting connections for looseness    (c) Installing updates to a spreadsheet application only    (d) Cleaning accumulated dust safely
  25. The main reason to apply least-privilege access to a school database is to ________. (a) allow every user to modify examination scores    (b) limit each account to the data and actions needed for its work    (c) make administrator accounts available to visitors    (d) remove the requirement to authenticate users
  26. Which action does NOT respect separation of database privileges? (a) Giving every clerk permission to alter the master examination table    (b) Granting read-only access for approved reports    (c) Restricting backups to authorised staff    (d) Recording administrative account use
  27. All these activities support database recovery except ________. (a) recording transactions    (b) retaining usable backups    (c) discarding the only recovery log before a successful restoration    (d) testing recovery procedures
  28. The correct step when a star network loses access for one workstation is to ________. (a) assume the whole central switch has failed without testing    (b) delete the school’s database    (c) disable all user authentication    (d) check that workstation’s cable or switch port before replacing the whole network
  29. Which of these is not a network topology? (a) Secondary-key indexing    (b) Ring    (c) Star    (d) Bus
  30. The ________ problem becomes especially important when a distributed database replicates records at several sites. (a) choosing a fixed presentation theme for all reports    (b) maintaining consistency between copies    (c) avoiding conflict checks when replicated records differ    (d) removing every record’s identifying fields
  31. The correct step when queries filter on two fields together repeatedly is to ________. (a) evaluate whether a composite index matches the common search order    (b) build unrelated indexes without examining the query workload    (c) remove the frequently used fields    (d) disable all integrity constraints to accelerate search
  32. A network with every workstation connected through a central switch has a ________ topology. (a) bus    (b) star    (c) ring    (d) mesh with all nodes directly linked
  33. Which action does NOT follow sound index design? (a) Index every column blindly without considering update overhead    (b) Review common search predicates    (c) Consider index maintenance cost    (d) Choose keys that support frequent queries
  34. Which of the following index designs is most appropriate for repeated lookups by surname and given name together? (a) An index only on student age    (b) An index on the last login timestamp    (c) A composite index on surname and given name    (d) Removing all search keys from the table
  35. A transaction’s COMMIT record exists but its updated page was not saved before a crash. Under write-ahead recovery, the system may need to ________. (a) roll back every committed change permanently    (b) replace the transaction with a network topology    (c) treat the recorded commit as a virus warning    (d) redo the committed update from the log
  36. ________ helps protect stored or transmitted information from unauthorised reading by converting it to coded form. (a) Disk defragmentation    (b) Screen calibration    (c) Encryption    (d) Physical cable labelling
  37. The main reason a search index can speed up a database query is that it ________. (a) reduces the data locations that must be examined for a search    (b) eliminates every disk write during updates    (c) guarantees faster performance for every query regardless of design    (d) removes the need for correct keys
  38. All these strengthen database access security except ________. (a) strong user authentication    (b) role-based authorisation    (c) auditing privileged actions    (d) reusing one administrator password among all staff
  39. The correct step after a system crash interrupts a multi-step transaction is to ________. (a) assume every uncommitted write is valid    (b) use recovery records to determine which changes to redo or undo    (c) erase the transaction log before inspecting it    (d) let unauthorised users rewrite the tables
  40. ________ requires relevant transaction log records to be recorded before the associated modified data are written to disk. (a) The bus topology rule    (b) The composite-key convention    (c) The write-ahead logging protocol    (d) The file-compression procedure

SECTION B: THEORY (30 Marks)
Instruction: Answer Question 1 and any other TWO questions. Each question carries 10 marks.

1. Answer the following questions.
(a) A database stores student registration numbers, surnames and class codes. Explain FIVE index-design decisions that would improve frequent searches without ignoring maintenance costs. (5 marks)
(b) A clerk should view attendance but not alter marks. Propose FIVE access-control or security measures for the database. (5 marks)

2. Answer the following questions.
(a) A transaction is interrupted after a crash. Distinguish FIVE recovery tasks or principles involving backups and write-ahead logging. (5 marks)
(b) Identify FIVE operational risks if a school maintains a database without logging, backups or tested recovery. (5 marks)

3. Answer the following questions.
(a) Compare local, parallel and distributed data processing by explaining FIVE design or coordination considerations. (5 marks)
(b) A network spans two school campuses. Give FIVE design or troubleshooting considerations using the network topics taught. (5 marks)

4. Answer the following questions.
(a) A school reports pop-ups, corrupted files and unexplained computer restarts. Outline FIVE stages of investigation and protection. (5 marks)
(b) Explain FIVE distinctions between hardware and software maintenance, giving examples of each. (5 marks)


OBJECTIVE MARKING SCHEME
Question 1 – ✅ (b) A system managing logically related data stored across networked sites
Question 2 – ✅ (a) appearance
Question 3 – ✅ (c) a computer virus
Question 4 – ✅ (b) retain a recoverable copy if updates or failures damage data
Question 5 – ✅ (d) a possible malware infection requiring investigation
Question 6 – ✅ (b) Inspect ventilation and cooling for obstruction or faults
Question 7 – ✅ (d) identify work that can run in parallel while preserving correct results
Question 8 – ✅ (c) Shared access to authorised resources over a limited site
Question 9 – ✅ (d) cleaning dust from a computer’s internal fan
Question 10 – ✅ (b) a primary-secondary database index
Question 11 – ✅ (d) improved local access when the design and links are suitable
Question 12 – ✅ (a) Registration number
Question 13 – ✅ (b) Installing unknown software from untrusted sources
Question 14 – ✅ (c) verify the sender and scan the file before opening it
Question 15 – ✅ (d) independent portions of the work can be executed concurrently
Question 16 – ✅ (a) the index may not efficiently support a surname-only search
Question 17 – ✅ (c) database administrator
Question 18 – ✅ (d) Rollback reverses incomplete work; redo reapplies recorded committed changes
Question 19 – ✅ (a) Coordinating transactions across separate sites
Question 20 – ✅ (c) Role-based permissions with restricted update rights
Question 21 – ✅ (a) Wide area network
Question 22 – ✅ (b) secondary index
Question 23 – ✅ (d) Guaranteeing that database information never needs backups
Question 24 – ✅ (c) Installing updates to a spreadsheet application only
Question 25 – ✅ (b) limit each account to the data and actions needed for its work
Question 26 – ✅ (a) Giving every clerk permission to alter the master examination table
Question 27 – ✅ (c) discarding the only recovery log before a successful restoration
Question 28 – ✅ (d) check that workstation’s cable or switch port before replacing the whole network
Question 29 – ✅ (a) Secondary-key indexing
Question 30 – ✅ (b) maintaining consistency between copies
Question 31 – ✅ (a) evaluate whether a composite index matches the common search order
Question 32 – ✅ (b) star
Question 33 – ✅ (a) Index every column blindly without considering update overhead
Question 34 – ✅ (c) A composite index on surname and given name
Question 35 – ✅ (d) redo the committed update from the log
Question 36 – ✅ (c) Encryption
Question 37 – ✅ (a) reduces the data locations that must be examined for a search
Question 38 – ✅ (d) reusing one administrator password among all staff
Question 39 – ✅ (b) use recovery records to determine which changes to redo or undo
Question 40 – ✅ (c) The write-ahead logging protocol


THEORY MARKING SCHEME (Answer 3 × 10 = 30 Marks)
Question 1 (10 Marks)
(a) 5 marks: Identify frequent query predicates (1); unique registration-number key (1); composite keys where queries use multiple fields (1); secondary index on other searched fields (1); account for update and storage overhead (1).
(b) 5 marks: Unique authentication (1); restricted role permissions (1); prevent unauthorised writes (1); protect sensitive data with appropriate encryption (1); audit privilege use (1).
Question 2 (10 Marks)
(a) 5 marks: Log before page update (1); identify committed transactions (1); redo committed updates if needed (1); undo uncommitted changes (1); restore or verify suitable backup when necessary (1).
(b) 5 marks: Loss of committed work (1); inconsistent partial transactions (1); prolonged service interruption (1); inability to recover earlier state (1); poor confidence in records (1).
Question 3 (10 Marks)
(a) 5 marks: Local site access (1); concurrent execution for parallel processing (1); distributed storage across sites (1); consistency of replicas (1); communication and transaction coordination (1).
(b) 5 marks: Appropriate WAN/inter-site links (1); LAN topology within each site (1); identify central device and link faults (1); control resource sharing (1); maintain physical connections (1).
Question 4 (10 Marks)
(a) 5 marks: Recognise malware symptoms (1); isolate or contain suspected system (1); scan with updated trusted security software (1); check suspicious downloads and attachments (1); restore and verify unaffected records (1).
(b) 5 marks: Hardware: ventilation or dust cleaning (1), inspecting physical connections (1); software: patching (1), scanning for malware (1), verifying backups or system integrity (1).

Export this post
First Term Data Processing Examination for SS 3
About the author

Royal Alikor

Royal Alikor is an educator with six years of classroom teaching and three years of elementary school leadership experience. He develops and reviews practical, curriculum-aligned learning materials for Nigerian schools.

Community Join the conversation Open discussion +