S3 · UCE Information and Communications Technology · Term 3

Database Management Systems S3 Information and Communications Technology questions and answers

10 practice questions on Database Management Systems in the Elaarn app, marked line by line like the exam.

Installed it? Come back and tap Open in Elaarn.

Database Management Systems: sample questions with answers

Work each one out first, then open the answer. The full working and your marks are in the app.

  1. Question 1

    Which field would make the best primary key in a students table: name, class or student number?

    Show answer

    Answer: student number

  2. Question 2

    Explain the difference between a query, a form and a report.

    Show answer

    Answer: A query asks a question / finds data that meets conditions; A form is used to enter or view data, one record at a time; A report presents data in a printable, organised format

  3. Question 3

    A clinic's patients table has fields: PatientID, Name, Village, Age, LastVisit. Describe a query to list patients from Bweyale aged under 5.

    Show answer

    Answer: Create a query on the Patients table; Criteria for Village = "Bweyale"; Criteria for Age < 5 (both conditions together: AND); Show the fields needed, e.g. Name, Age, LastVisit

What you practise in Database Management Systems

  • Databases, tables, records and fields
  • Data types and primary keys
  • Queries, forms and reports
  • Uses of databases

More S3 Information and Communications Technology topics

← Electronic Publication

All S3 Information and Communications Technology questions and answers · UCE revision

Lower secondary · S3 · Information and Communications Technology · Data Management and Sharing. Elaarn covers every class from P1 to S6. About Elaarn