S6 ICT Databases and SQL Practice (Paper 1: Basics)
- 2026-11-17
S6 ICT Databases and SQL Practice (Paper 1: Basics)
Start from the definitions: what a row is, what a primary key needs, and what SELECT and COUNT return.
Separate rows from columns, then look at the primary key Paper 1 sets the base. A table is made of rows (records) and columns (fields). SELECT * takes every column but leaves the row count alone, so a table of 30 rows still returns 30 rows, and COUNT(*) counts rows, so 24 rows give 24. A primary key must be unique and never NULL because it identifies one row. WHERE filters, AND needs both conditions, ORDER BY Mark DESC sorts from high to low, INSERT adds, UPDATE changes and DELETE removes. The last item corrects the common claim that a primary key may repeat.
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: S6 ICT: Databases and SQL |
| Level | Basics (S6 ICT) |
02 Questions (10 items)
- FoundationTable Student has 30 rows. How many rows does SELECT * FROM Student; return?
- FoundationStudent has 24 rows. What does SELECT COUNT(*) FROM Student; return?
- FoundationWhich two conditions must a primary key satisfy?
- FoundationWhat does SELECT Name FROM Student WHERE Class = ‘6A’; return?
- IntermediateWhat does WHERE Age >= 16 AND Gender = ‘F’ mean?
- IntermediateWhat does ORDER BY Mark DESC do?
- ChallengeWhat does INSERT INTO Student (Name, Class) VALUES (‘Chan Tai Man’, ‘6A’); do?
- ChallengeDELETE FROM Student WHERE Class = ‘6A’; is run and class 6A has 5 rows. How many rows are deleted?
- Error redoAfter UPDATE Student SET Class = ‘6B’ WHERE Name = ‘Chan Tai Man’; what is that row’s Class?
- Error redoA student claims a primary key may repeat as long as it is not empty. What is wrong?
03 Answers and one-line notes
| # | Answer | One-line note |
|---|---|---|
| 1 | 30 rows. | SELECT * only takes every column; it does not change the number of rows. |
| 2 | 24. | COUNT(*) counts rows, not columns. |
| 3 | Every value is unique and no value may be NULL. | A primary key identifies a row uniquely, so it can neither repeat nor be empty. |
| 4 | The Name column of the students in class 6A. | Only Name is listed after SELECT, so no other column comes back. |
| 5 | Age 16 or above and female at the same time. | AND requires both conditions to hold. |
| 6 | Sorts by Mark from highest to lowest. | DESC means descending; ASC, the default, is ascending. |
| 7 | It adds one new row to Student. | INSERT INTO adds a row; existing rows are untouched. |
| 8 | 5 rows. | WHERE matches only the 5 rows of class 6A; other classes are untouched. |
| 9 | 6B. | UPDATE … SET writes the new value into the matched row. |
| 10 | Wrong. A primary key must be unique; a repeated value cannot be a primary key. | If two rows share a primary key, neither can be identified uniquely, which breaks the definition. |
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.
After paper 1, revisit the table structure diagrams on the chapter page, then try the aggregate and JOIN items in paper 2.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.



