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.
Question 1
Which field would make the best primary key in a students table: name, class or student number?
Show answer
Answer: student number
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
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
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