Paper 4: Retry: correcting ten common slips
Chapter practice with ten items, answers and a one-line note for each, about 25 minutes.
| 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 |
| # | 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. |
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.

