Paper 1: Basics: tables, SELECT and primary keys
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 | Basic |
| # | 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. |
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.

