Database: Introduction, Tables & Basic Queries is one of 9 topics in the Grade 11 Computer Applications 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. What is a "field" in a database table?
A single specific category of data stored within a table, represented as a column
A complete single entry, represented as a row
The entire database file itself
A type of network connection
Answer: A single specific category of data stored within a table, represented as a column — A field is a single specific category of data stored within a table, represented as a column, such as FirstName or DateOfBirth.
Easy
2. What is a "record" in a database table?
One complete, single entry within a table, represented as a row
A single column of data
The name of the entire database
A type of data type
Answer: One complete, single entry within a table, represented as a row — A record is one complete, single entry within a table, represented as a row, containing a value in every field for one specific item.
Medium
3. Give the term for a special field whose value must be unique for every record, used to reliably identify one specific record in a table.
Answer: a primary key — A primary key is a special field (or combination of fields) whose value must be unique for every record, used to reliably identify one specific record.
