S2 ICT database tables and queries practice 4: ten retry items
- 2026-11-20
S2 ICT database tables and queries practice 4: ten retry items
Ten items correcting the most frequent slips one by one: blank or repeated primary keys, treating a record as a column, reading greater than as greater than or equal to, mixing AND with OR, believing sorting removes records, and confusing a total with an average.
S2 ICT database practice 4: ten retry items A primary key must be unique and never blank, a record is a row, greater than excludes equality, sorting leaves the count alone and a foreign key may repeat. The average is three against a total of fifteen, and two of five records are forty per cent. Every item comes from real marking, each with a note.
01 Paper details (check answers afterwards)
| Item | Detail |
|---|---|
| Questions | 10 |
| Suggested time | 25 |
| Difficulty mix | Foundation 3 · Intermediate 3 · Challenge 3 · Error redo 1 |
| Chapter | Chapter: S2 ICT: Database tables and queries |
| Level | Error review |
02 Questions (10 items)
- FoundationMay a primary key be left blank?
- FoundationMay a primary key repeat?
- FoundationIs a record a row or a column?
- IntermediateDoes the filter Year > 2015 include the 2015 book?
- IntermediateOn the same data, Chan with year from 2019 returns one record while the OR form returns two. Why?
- IntermediateDoes sorting change the number of records?
- ChallengeIn a LIKE condition, what does the wildcard after a prefix stand for?
- ChallengeMay a foreign key repeat inside its own table?
- ChallengeThe five Copies values are three, two, five, four and one. Is the average three or fifteen?
- Error redoTwo of five records belong to Chan. Is that forty per cent or twenty-five per cent?
03 Answers and one-line notes
| # | Answer | One-line note |
|---|---|---|
| 1 | No, a primary key must be unique and never empty | An empty key identifies nothing, so the database rejects it. |
| 2 | No, a repeat destroys its identifying purpose | Uniqueness is the definition of a primary key. |
| 3 | A record is a row while a field is a column | One record is one line of the table. |
| 4 | No, Year >= 2015 is needed to include it | Greater than excludes equality. |
| 5 | AND requires both conditions while OR needs only one | One operator narrows the set and the other widens it. |
| 6 | No, it only changes display order | Sorting rearranges positions without adding or removing rows. |
| 7 | Any number of following characters, so it is a prefix match | The wildcard is a pattern symbol rather than a literal character. |
| 8 | Yes, since one book can have many loan records | A foreign key only needs a match in the other table, not uniqueness at home. |
| 9 | The average is three, and fifteen is the total | An average divides by the record count while a total does not. |
| 10 | Forty per cent, that is two divided by five | The denominator of the percentage is the total record count. |
04 What to do after marking
- After marking, redo only the wrong items and write down which step went wrong (formula, unit, or misread number).
- Repeat the same item two days later; move to the next paper only when both attempts are correct.
- Parents only need the answer and note columns; there is no need to explain every item.
To keep practising queries and filters for this chapter, work through the other three papers, moving from foundation up to challenge.Tutor Registration →
Questions and answers are written originally by the TutorZone team and are not taken from any school, publisher or examination authority paper. Every value is checked by computer.



