Database Design, Relationships & Queries is one of 10 topics in the Grade 11 Information Technology CAPS syllabus, covered across 3 lessons on Study Vault. Below are real practice questions from this topic with full worked answers.
Sample practice questions
Easy
1. In a database table, what does a "field" (or column) represent?
One specific piece of information to be stored about the thing the table represents
An entire completed table containing many records
A query used to retrieve data from a table
A separate database stored on a different computer
Answer: One specific piece of information to be stored about the thing the table represents — A field (or column) represents one specific piece of information to be stored about the thing the table represents, such as a FirstName field.
Easy
2. What is a "record" in a database table?
One individual entry in the table, representing one specific real-world instance
A field that stores only numeric values
The name given to the entire database file
A query used to sort data
Answer: One individual entry in the table, representing one specific real-world instance — A record is one individual entry in a table, representing one specific real-world instance, such as one specific learner.
Medium
3. Name the maintenance action that means changing one or more field values within an existing record to keep it accurate.
Answer: editing — Editing a record means changing one or more field values within an existing record to keep it accurate.
