IGCSE Computer Science Paper 2 Word Scramble: 8.3 File Handling and 9 Databases (Modules 500–522)
Name:
Date:
Class:
🔤
Word scramble
Unscramble the letters and write each key term on the line.
1
TRIEW, ELLCIFEOS, AERD
Open a file for WRITE, store data with WRITEFILE, then CLOSEFILE. Reopen the same file name for READ and READFILE gets the data back to use again.
2
ATERC ETALB
A table that follows a program step by step, recording the file contents and each variable's value after every file command, until you find the final OUTPUT.
3
LIFE NHLNAIDG RRERO
A mistake such as using the wrong mode, missing OPENFILE or CLOSEFILE, using different file names, or opening a file FOR WRITE and wiping its old data.
4
IELFD DAN ERDCOR
A field is a column and a record is one data row. The heading row is not a record. A table with 4 fields and 6 records has 4 columns and 7 rows including the heading.
5
TCEHRAACR DFEIL
A ______ holds exactly one character, like a grade A-E or an M/F code. A text field holds a string of any length, like a name or a postcode.
6
ALADVITION ECHCK
A rule that tests data on entry. Pick the one that fits each field: range for a mark, length for a phone number, presence for a required name, list for a year group.
7
AYPMRRI EKY
The field chosen to identify each record. Its values must be unique and never blank, like an ID number. Names and dates of birth can repeat, so they are unsuitable.
8
EATBL ERURTTSUC
The plan for one table: list each field the scenario needs, give it a data type and any validation, and choose a primary key so the table can hold every record.
Answer Key
IGCSE Computer Science Paper 2 · Modules 500–522
1TRIEW, ELLCIFEOS, AERD → WRITE, CLOSEFILE, READ — Open a file for WRITE, store data with WRITEFILE, then CLOSEFILE. Reopen the same file name for READ and READFILE gets the data back to use again.
2ATERC ETALB → trace table — A table that follows a program step by step, recording the file contents and each variable's value after every file command, until you find the final OUTPUT.
3LIFE NHLNAIDG RRERO → file handling error — A mistake such as using the wrong mode, missing OPENFILE or CLOSEFILE, using different file names, or opening a file FOR WRITE and wiping its old data.
4IELFD DAN ERDCOR → field and record — A field is a column and a record is one data row. The heading row is not a record. A table with 4 fields and 6 records has 4 columns and 7 rows including the heading.
5TCEHRAACR DFEIL → character field — A character field holds exactly one character, like a grade A-E or an M/F code. A text field holds a string of any length, like a name or a postcode.
6ALADVITION ECHCK → validation check — A rule that tests data on entry. Pick the one that fits each field: range for a mark, length for a phone number, presence for a required name, list for a year group.
7AYPMRRI EKY → PRIMARY KEY — The field chosen to identify each record. Its values must be unique and never blank, like an ID number. Names and dates of birth can repeat, so they are unsuitable.
8EATBL ERURTTSUC → table structure — The plan for one table: list each field the scenario needs, give it a data type and any validation, and choose a primary key so the table can hold every record.