IGCSE Computer Science Paper 2 Crossword: 9 Databases (Modules 525–538)
Name:
Date:
Class:
✎
Crossword
Read each clue and write the matching term in the grid. Numbers in brackets show the letters in each word.
1
2
3
4
5
6
7
8
9
10
Across
- 3. Adds up all the values in a numeric ______ and returns one total, e.g. SELECT SUM(Score) FROM Results; gives one row. It only works on numbers. Word 2 of: SUM(_____) (5)
- 4. The output has only the fields named, as columns in the order written after SELECT, with a heading row of field names and one row per record kept (all records if there is no WHERE). Word 5 of: SELECT lastName, firstName FROM ________; (8)
- 9. SQL function that counts records. SELECT ______ FROM Students; outputs one row with the number of records in the table. It counts rows, whereas SUM adds up values. (5)
- 10. The ______ of clauses in a full SQL query: SELECT, FROM, WHERE, then ______ BY. WHERE filters the rows first, then ______ BY sorts the rows that are left. Word 4 of: SELECT FROM _____ _____ BY (5)
Down
- 1. Turn a request into one SQL statement: pick ______ after SELECT, the table after FROM, conditions in WHERE, sort with ORDER BY, and use SUM or COUNT for totals and how many. Word 2 of: SELECT ______ FROM _____ _____ condition _____ BY _____ ____; (6)
- 2. The value in a ______ condition must match the field's data type: text and characters go in quotes, numbers do not, and Boolean fields use TRUE or FALSE, e.g. Member = TRUE. Word 3 of: _____ ____ = '_____' (5)
- 5. Completing an SQL script: read the task, then fill the gap with the right field, WHERE condition, ASC or DESC, AND or OR, or SUM or COUNT so the query returns exactly what is asked. Word 4 of: SELECT _____ FROM _____ _____ condition; (5)
- 6. Word 10 of the term in 1 Down: SELECT ______ FROM _____ _____ condition _____ BY _____ ____; (4)
- 7. Word 2 of the term in 2 Down: _____ ____ = '_____' (4)
- 8. Word 1 of the term in 2 Down: _____ ____ = '_____' (5)
Answer Key
IGCSE Computer Science Paper 2 · Modules 525–538
1F
2L
I
3F
I
E
L
D
E
E
L
D
D
4S
5T
U
6D
E
N
7T
S
8W
A
E
O
H
B
S
W
E
L
9C
O
U
N
T
10O
R
D
E
R
E
Across
3FIELD — Adds up all the values in a numeric ______ and returns one total, e.g. SELECT SUM(Score) FROM Results; gives one row. It only works on numbers. Word 2 of: SUM(_____)
4STUDENTS — The output has only the fields named, as columns in the order written after SELECT, with a heading row of field names and one row per record kept (all records if there is no WHERE). Word 5 of: SELECT lastName, firstName FROM ________;
9COUNT — SQL function that counts records. SELECT ______ FROM Students; outputs one row with the number of records in the table. It counts rows, whereas SUM adds up values.
10ORDER — The ______ of clauses in a full SQL query: SELECT, FROM, WHERE, then ______ BY. WHERE filters the rows first, then ______ BY sorts the rows that are left. Word 4 of: SELECT FROM _____ _____ BY
Down
1FIELDS — Turn a request into one SQL statement: pick ______ after SELECT, the table after FROM, conditions in WHERE, sort with ORDER BY, and use SUM or COUNT for totals and how many. Word 2 of: SELECT ______ FROM _____ _____ condition _____ BY _____ ____;
2LEEDS — The value in a ______ condition must match the field's data type: text and characters go in quotes, numbers do not, and Boolean fields use TRUE or FALSE, e.g. Member = TRUE. Word 3 of: _____ ____ = '_____'
5TABLE — Completing an SQL script: read the task, then fill the gap with the right field, WHERE condition, ASC or DESC, AND or OR, or SUM or COUNT so the query returns exactly what is asked. Word 4 of: SELECT _____ FROM _____ _____ condition;
6DESC — Word 10 of the term in 1 Down: SELECT ______ FROM _____ _____ condition _____ BY _____ ____;
7TOWN — Word 2 of the term in 2 Down: _____ ____ = '_____'
8WHERE — Word 1 of the term in 2 Down: _____ ____ = '_____'