QCE Digital Solutions Unit 2 Word Scramble: Data and Programming Techniques (Modules 186–228)
Name:
Date:
Class:
🔤
Word scramble
Unscramble the letters and write each key term on the line.
1
VLYALIITBAIA
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.
2
RETSMA
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.
3
ITFELR
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.
4
PAM
______() 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.
5
TAAGGRGEE
To ______ is to combine many records into one summary value, such as a running total, a count of matching records, or an average worked out after the loop.
6
TLARE ATLBE
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.
7
ECRATE EIWV
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.
8
EADROSNCY EKY
A non-primary field used to search or sort records, such as surname. Unlike a primary key, its values need not be unique, and it is often indexed to make searches faster.
9
LLUN
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 ______.
Answer Key
QCE Digital Solutions Unit 2 · Modules 186–228
1VLYALIITBAIA → Availability — 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.
2RETSMA → stream — 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.
3ITFELR → filter — 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.
4PAM → map — map() 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.
5TAAGGRGEE → aggregate — To aggregate is to combine many records into one summary value, such as a running total, a count of matching records, or an average worked out after the loop.
6TLARE ATLBE → ALTER TABLE — 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.
7ECRATE EIWV → CREATE VIEW — 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.
8EADROSNCY EKY → secondary key — A non-primary field used to search or sort records, such as surname. Unlike a primary key, its values need not be unique, and it is often indexed to make searches faster.
9LLUN → NULL — A field with no value at all. It is not zero and not an empty string. Test for it with IS NULL, never = NULL. A primary key can never be NULL.