QCE Digital Solutions Unit 2 Crossword: Data and Programming Techniques (Modules 186–228)
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. A non-primary field used to search or sort records, such as surname. Unlike a primary ______, its values need not be unique, and it is often indexed to make searches faster. Word 1 of: _________ ___ (9)
- 7. A sequence of structured records that arrives or is read one at a time, such as sensor readings, file lines or API results, and is processed as it flows. (6)
- 9. Authorised users can reach data and systems when they need them. Hardware failure and attacks can threaten it, so backups and protection keep a system running. (12)
- 10. Word 2 of the term in 3 Across: _________ ___ (3)
Down
- 1. An SQL command that changes the structure of an existing table, such as adding a column with ADD, removing one with DROP COLUMN, or adding a FOREIGN KEY, without deleting the table. Word 1 of: _____ TABLE (5)
- 2. Saves a SELECT query as a named virtual table. It shows chosen columns and rows, can hide others, and stores no copy of the data, so you query it like a table. Word 2 of: ______ ____ (4)
- 4. Word 1 of the term in 2 Down: ______ ____ (6)
- 5. A field with no value at all. It is not zero and not an empty string. Test for it with IS ______, never = ______. A primary key can never be ______. (4)
- 6. Keep only the records in a stream that meet a condition and discard the rest, usually with an if inside a loop that adds matches to a result list. (6)
- 8. ______() applies a function to every record in a stream and gives back changed records, such as converting a type, trimming and changing the case of text, or computing a derived field. (3)
Answer Key
QCE Digital Solutions Unit 2 · Modules 186–228
1A
2V
3S
E
4C
O
5N
D
A
R
Y
6F
L
I
R
U
I
7S
T
R
E
A
8M
E
L
L
E
W
9A
V
A
I
L
A
B
I
L
I
T
Y
R
P
T
E
10K
E
Y
R
Across
3SECONDARY — A non-primary field used to search or sort records, such as surname. Unlike a primary ______, its values need not be unique, and it is often indexed to make searches faster. Word 1 of: _________ ___
7STREAM — A sequence of structured records that arrives or is read one at a time, such as sensor readings, file lines or API results, and is processed as it flows.
9AVAILABILITY — Authorised users can reach data and systems when they need them. Hardware failure and attacks can threaten it, so backups and protection keep a system running.
10KEY — Word 2 of the term in 3 Across: _________ ___
Down
1ALTER — An SQL command that changes the structure of an existing table, such as adding a column with ADD, removing one with DROP COLUMN, or adding a FOREIGN KEY, without deleting the table. Word 1 of: _____ TABLE
2VIEW — Saves a SELECT query as a named virtual table. It shows chosen columns and rows, can hide others, and stores no copy of the data, so you query it like a table. Word 2 of: ______ ____
4CREATE — Word 1 of the term in 2 Down: ______ ____
5NULL — A field with no value at all. It is not zero and not an empty string. Test for it with IS ______, never = ______. A primary key can never be ______.
6FILTER — Keep only the records in a stream that meet a condition and discard the rest, usually with an if inside a loop that adds matches to a result list.
8MAP — ______() applies a function to every record in a stream and gives back changed records, such as converting a type, trimming and changing the case of text, or computing a derived field.