Database: Queries, Reports & Design is one of 9 topics in the Grade 12 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. Which query operator requires EVERY specified condition to be true for a record to be included in the results?
AND
OR
NOT
IS NULL
Answer: AND — The AND operator requires every specified condition to be true for a record to be included in the query results.
Easy
2. Which wildcard typically represents any number of unknown characters in a query search pattern?
An asterisk (*)
A question mark (?)
A hash (#)
A percent sign (%) only
Answer: An asterisk (*) — An asterisk (*) typically represents any number of unknown characters in a wildcard search pattern, such as "S*" matching any text starting with S.
Medium
3. Name the query operator that specifically matches records where a given field has been left completely empty, with no value entered at all.
Answer: IS NULL — The IS NULL operator matches records where a given field has been left completely empty, distinct from searching for a blank text value or a zero.
