IGCSE Computer Science Paper 2 Word Scramble: 9 Databases (Modules 525–538)
Name:
Date:
Class:
🔤
Word scramble
Unscramble the letters and write each key term on the line.
1
EWEHR WTNO = 'SDLEE'
The value in a WHERE 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.
2
EEWHR (A RO B) DAN C
Brackets make SQL work out the OR first, then the AND. A record must meet C and also A or B. Moving the brackets, as in A OR (B AND C), can return different records.
3
FEI(USDLM)
Adds up all the values in a numeric field and returns one total, e.g. SELECT SUM(Score) FROM Results; gives one row. It only works on numbers.
4
NOTCU(*)
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
REWEH, DEROR YB, CLSTEE
To find a query's output, first keep the rows that pass WHERE, then sort them with ORDER BY, then show only the SELECT fields or the SUM or COUNT result.
Answer Key
IGCSE Computer Science Paper 2 · Modules 525–538
1EWEHR WTNO = 'SDLEE' → WHERE Town = 'Leeds' — The value in a WHERE 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.
2EEWHR (A RO B) DAN C → WHERE (A OR B) AND C — Brackets make SQL work out the OR first, then the AND. A record must meet C and also A or B. Moving the brackets, as in A OR (B AND C), can return different records.
3FEI(USDLM) → SUM(field) — Adds up all the values in a numeric field and returns one total, e.g. SELECT SUM(Score) FROM Results; gives one row. It only works on numbers.
4NOTCU(*) → COUNT(*) — SQL function that counts records. SELECT COUNT(*) FROM Students; outputs one row with the number of records in the table. It counts rows, whereas SUM adds up values.
5REWEH, DEROR YB, CLSTEE → WHERE, ORDER BY, SELECT — To find a query's output, first keep the rows that pass WHERE, then sort them with ORDER BY, then show only the SELECT fields or the SUM or COUNT result.