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

Paper 4: Retry: correcting ten common slips

Paper 4: Retry: correcting ten common slips

  • 2026-11-21

Paper 4: Retry: correcting ten common slips

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

Paper 4 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 Retry

02 Questions (10 items)

  1. FoundationA query `SELECT * FROM students` has no WHERE clause. How many rows come back?
  2. FoundationWhat is wrong with `WHERE score => 70`?
  3. FoundationDoes `ORDER BY score DESC` sort from low to high?
  4. FoundationMay two rows share the same primary key value?
  5. IntermediateDoes `DELETE FROM students;` remove the table structure as well?
  6. IntermediateWhat happens if `UPDATE students SET score = 0;` is run without WHERE?
  7. ChallengeDoes INNER JOIN keep left table rows that have no match?
  8. ChallengeWhat is the difference between `COUNT(*)` and `COUNT(score)`?
  9. Error redoShould string values use single or double quotes?
  10. Error redoAn index speeds up queries. What does it cost on writes?

03 Answers and one-line notes

# Answer One-line note
1 8, the whole table. With no WHERE clause nothing is filtered, so all eight rows return.
2 The comparison signs are reversed; the correct form is `score >= 70`. `=>` is not a SQL comparison operator, so the statement raises a syntax error.
3 No, DESC sorts high to low, and the largest is 95. Ascending order needs ASC instead.
4 No, every primary key value must be unique. The database refuses any insert that repeats an existing key value.
5 No, it only empties the rows and the table still exists. Removing the whole table needs DROP TABLE instead.
6 All 8 rows are set to 0. An UPDATE without WHERE applies to every row of the table.
7 No, only LEFT JOIN keeps every row of the left table. INNER JOIN outputs a row only when both sides match.
8 `COUNT(score)` ignores NULL values, while `COUNT(*)` counts every row. Once a blank value exists the two results differ.
9 Use single quotes, for example name = ‘Amy’. Some systems read double quotes as column names, which is unsafe.
10 Every insert, update or delete must refresh the index, so writes slow down. More indexes are not always better; they should follow the queries actually used.

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 →