/en-tutor-prep-s2-ict-databases-tables-queries-practice-4/
/en-tutor-prep-s2-ict-databases-tables-queries-practice-4/
General Inquiry: info@TutorZone.com.hk
Office Hours: Monday to Saturday - 9:00 AM to 6:00 PM
WhatsApp Monday to Sunday - 24 hours
Hotline: +852 6828 1809
Instant Support: +852 9061 3106

S2 ICT database tables and queries practice 4: ten retry items

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)

  1. FoundationMay a primary key be left blank?
  2. FoundationMay a primary key repeat?
  3. FoundationIs a record a row or a column?
  4. IntermediateDoes the filter Year > 2015 include the 2015 book?
  5. IntermediateOn the same data, Chan with year from 2019 returns one record while the OR form returns two. Why?
  6. IntermediateDoes sorting change the number of records?
  7. ChallengeIn a LIKE condition, what does the wildcard after a prefix stand for?
  8. ChallengeMay a foreign key repeat inside its own table?
  9. ChallengeThe five Copies values are three, two, five, four and one. Is the average three or fifteen?
  10. 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.

Join as a tutor or coach — academic, music, sports, arts, STEM. Free to register. See how it works →