/en-tutor-prep-s3-ict-databases-sql-queries-practice-1/
/en-tutor-prep-s3-ict-databases-sql-queries-practice-1/
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

Paper 1: Basics: tables, SELECT and primary keys

Paper 1: Basics: tables, SELECT and primary keys

  • 2026-11-21

Paper 1: Basics: tables, SELECT and primary keys

Chapter practice with ten items, answers and a one-line note for each, about 25 minutes.

Paper 1 Ten items on this chapter with answers for immediate marking.

01 Paper details (check answers afterwards)

Item Detail
Questions 10
Suggested time 25
Difficulty mix Foundation 4 · Intermediate 2 · Challenge 2 · Error redo 2
Chapter Chapter: S3 ICT: databases and SQL queries
Level Basic

02 Questions (10 items)

  1. FoundationTable students has four columns: id, name, form and score. How many columns does `SELECT * FROM students;` return?
  2. FoundationTable students stores the records of eight pupils. How many rows does `SELECT * FROM students;` return?
  3. FoundationHow many columns does `SELECT name, score FROM students;` return?
  4. FoundationHow many rows does `SELECT * FROM students WHERE form = 1;` return?
  5. IntermediateWhat conditions must a primary key satisfy?
  6. IntermediateWhat is the result of `SELECT COUNT(*) FROM students;`?
  7. ChallengeWhat is the result of `SELECT SUM(score) FROM students;`?
  8. ChallengeWhat is the result of `SELECT ROUND(AVG(score), 2) FROM students;`?
  9. Error redoWhat do `SELECT MAX(score)` and `SELECT MIN(score)` give?
  10. Error redoA pupil claims `SELECT *` means every table in the database. Is that right?

03 Answers and one-line notes

# Answer One-line note
1 4 columns. `*` stands for every column of that table, so all four are returned.
2 8 rows. A SELECT without WHERE returns every row held in the table.
3 2 columns. Only the two listed columns are produced, so the result has two columns.
4 3 rows. Three pupils sit in form 1, so only those three rows pass the filter.
5 Every value must be unique and must not be left empty. The key identifies a single row, so blanks and duplicates are refused.
6 8. COUNT(*) counts row by row, and the table holds eight rows.
7 580. SUM adds the eight values held in the score column.
8 72.5. AVG divides the total by the row count, and ROUND keeps two decimals.
9 A maximum of 95 and a minimum of 50. MAX returns the largest value and MIN the smallest, each as a single number.
10 No, `*` means every column of the table named in FROM. To read another table it has to be named after FROM.

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.

Want the whole chapter? See all four difficulty papers on the chapter page.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 →