/en-tutor-prep-s2-ict-databases-tables-queries-practice-2/
/en-tutor-prep-s2-ict-databases-tables-queries-practice-2/
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 2: projection, sorting and percentages

S2 ICT database tables and queries practice 2: projection, sorting and percentages

  • 2026-11-20

S2 ICT database tables and queries practice 2: projection, sorting and percentages

Ten items separating column choice from record filtering, then covering greater than or equal to, multi-column sorting, part of whole percentages and the prefix wildcard, closing on the greater than versus greater than or equal to confusion.

S2 ICT database practice 2: ten advanced items Copies at three or more gives three records, the average is three copies, largest minus smallest is four, Chan holds forty per cent and B003 keeps sixty per cent after two loans. Ten items on multi-column sorting and prefix matching, 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 Intermediate

02 Questions (10 items)

  1. FoundationA query returns only the Title and Year columns. What is that operation called?
  2. FoundationWith the condition Copies >= 3, how many records match?
  3. FoundationWhat is the average of the Copies field?
  4. IntermediateBy how much do the largest and smallest Copies values differ?
  5. IntermediateSorting by Copies ascending and then by Year descending for ties is called what?
  6. IntermediateWhat percentage of all records are books by Chan?
  7. ChallengeB003 starts with five copies and two are lent out. What fraction of the original stock stays available?
  8. ChallengeWith the condition Year between 2016 and 2020 inclusive, how many records match?
  9. ChallengeA LIKE query on Physics followed by the wildcard finds titles starting with that word. How many records?
  10. Error redoA student filters with Year > 2015 and complains that the 2015 book disappeared. Is the result correct?

03 Answers and one-line notes

# Answer One-line note
1 Projection, that is choosing columns, while choosing records is selection Choosing columns and choosing rows are two separate operations.
2 Three records: three, five and four copies Greater than or equal to three counts, including exactly three.
3 Three copies, that is fifteen divided by five The mean equals the total divided by the number of records.
4 They differ by four, largest five and smallest one Largest minus smallest gives the range.
5 Multi-column sorting, where the secondary key acts only when the primary key ties Sort keys stack, with the second one resolving ties in the first.
6 Forty per cent, that is two divided by five A percentage is the part divided by the whole, times one hundred.
7 Three copies, that is sixty per cent Subtract the lent copies first, then divide by the original stock.
8 Three: 2016, 2018 and 2020 Inclusive bounds mean greater than or equal to and less than or equal to.
9 Two, namely B001 and B005 The wildcard stands for any number of characters, so a shared prefix is enough.
10 Yes, greater than excludes equality; Year >= 2015 would keep it Greater than and greater than or equal to are different conditions.

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 →