QCE Digital Solutions Unit 4 Crossword: Prototype Digital Data Exchanges (Modules 334–401)
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
- 1. Changes the structure of an existing table, such as adding a column with ADD or removing one with DROP COLUMN. Existing rows keep their data and get empty (NULL) values in a new column. Word 1 of: _____ TABLE (5)
- 5. Comparing the prototype's actual output with expected results worked out by hand from known data, to find wrong values such as rounding or conversion errors. Word 1 of: ________ testing (8)
- 6. A cipher that encrypts each letter with a random key letter. The key is as long as the message and is used once only, so it is unbreakable if used correctly. Word 3 of: one-time ___ (3)
- 7. A sub-______ is a ______ inside brackets in a WHERE clause. It runs first and its result is used by the outer query, e.g. to compare with an AVG or to match values using IN. (6)
- 9. Word 2 of the term in 3 Down: Security-______ __________ (6)
- 10. Filters groups after GROUP BY using an aggregate condition, e.g. ______ COUNT(*) > 2. WHERE filters rows before grouping. Order: WHERE, GROUP BY, ______. (6)
Down
- 2. Checking a prototype keeps working when the data source is offline, missing, empty, slow or sends malformed data, and gives consistent results on repeated runs. Word 1 of: ___________ testing (11)
- 3. Judging a data exchange on five aspects: use, dissemination, storage, accuracy and ownership of data, with evidence for each, then recommending a fix. Word 3 of: Security-______ __________ (10)
- 4. Turns a Python dictionary or list into JSON text (double-quoted keys, braces, square brackets) ready to send. json.loads() does the reverse and turns JSON text back into Python data. Word 2 of: json._____() (5)
- 8. Opens the SQLite database file school.db (creating it if missing) and returns a connection. Then ______.cursor() makes a cursor to run SQL, and ______.close() ends the connection. Word 1 of: ____ = sqlite3.connect("school.db") (4)
Answer Key
QCE Digital Solutions Unit 4 · Modules 334–401
1A
L
T
E
2R
E
3E
L
V
4D
I
5A
C
C
U
R
A
C
Y
L
M
B
U
P
I
6P
A
D
7S
E
L
E
8C
T
T
I
O
9I
M
P
A
C
T
N
O
Y
N
10H
A
V
I
N
G
Across
1ALTER — Changes the structure of an existing table, such as adding a column with ADD or removing one with DROP COLUMN. Existing rows keep their data and get empty (NULL) values in a new column. Word 1 of: _____ TABLE
5ACCURACY — Comparing the prototype's actual output with expected results worked out by hand from known data, to find wrong values such as rounding or conversion errors. Word 1 of: ________ testing
6PAD — A cipher that encrypts each letter with a random key letter. The key is as long as the message and is used once only, so it is unbreakable if used correctly. Word 3 of: one-time ___
7SELECT — A sub-______ is a ______ inside brackets in a WHERE clause. It runs first and its result is used by the outer query, e.g. to compare with an AVG or to match values using IN.
9IMPACT — Word 2 of the term in 3 Down: Security-______ __________
10HAVING — Filters groups after GROUP BY using an aggregate condition, e.g. ______ COUNT(*) > 2. WHERE filters rows before grouping. Order: WHERE, GROUP BY, ______.
Down
2RELIABILITY — Checking a prototype keeps working when the data source is offline, missing, empty, slow or sends malformed data, and gives consistent results on repeated runs. Word 1 of: ___________ testing
3EVALUATION — Judging a data exchange on five aspects: use, dissemination, storage, accuracy and ownership of data, with evidence for each, then recommending a fix. Word 3 of: Security-______ __________
4DUMPS — Turns a Python dictionary or list into JSON text (double-quoted keys, braces, square brackets) ready to send. json.loads() does the reverse and turns JSON text back into Python data. Word 2 of: json._____()
8CONN — Opens the SQLite database file school.db (creating it if missing) and returns a connection. Then ______.cursor() makes a cursor to run SQL, and ______.close() ends the connection. Word 1 of: ____ = sqlite3.connect("school.db")